I need to replace jpg description with a number

Closed
valentine76 Posts 1 Registration date Monday 25 February 2013 Status Member Last seen 25 February 2013 - 25 Feb 2013 à 12:51
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 25 Feb 2013 à 23:05
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 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
25 Feb 2013 à 23:05
then put the part number next to the jpgs column. 

what jpg column? question description seem to be incomplete