Previous Topic Next Topic

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

Answer 1 / 1
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
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