I need to replace jpg description with a number

Closed
valentine76
Posts
1
Registration date
Monday February 25, 2013
Status
Member
Last seen
February 25, 2013
- Feb 25, 2013 at 12:51 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Feb 25, 2013 at 11:05 PM
Hello,
I have thousands of jpgs that are named by a product description, like Beltwayjacketblack.jpg, and I need to replace jpg description with a part number.
My excel sheet has the full description in column A like: Icon One Thousand Beltway Motorcycle Jacket Resin Black Size Small. In column B is the part number: 2820-2513. I want excel to look in column A, match the jpg description with the full description, then put the part number next to the jpgs column.
Then I need to, somehow, batch change all the file names for the jpgs. Thanks for any and all help!



Related:

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Feb 25, 2013 at 11:05 PM
then put the part number next to the jpgs column. 

what jpg column? question description seem to be incomplete
0