Archived Notes

I sell lots of things to hardware stores. Retail stores keep track of items by their own internal number. We refer to those numbers as 'customer numbers' because we have lots of customers and customers each have their own numbers. They each call them the SKU number aka STOCK KEEPING UNIT. I had 450 image files listed by model number(our number) that needed to be changed to customer numbers(their number). Here's how i did it. Create an excel spreadsheet with current filename(with file extension) in column A Put the filename you want in column B. Put an equation in column C that is "ren " and column A and " " and column B. spreadsheet should look like this: Current Filename Filename You Want ="ren "&A1&" "&B1 10036.jpg B000HJDBAU.pt01.jpg ren 10036.jpg B000HJDBAU.pt01.jpg 10038.jpg B000VRDIA6.pt01.jpg ren 10038.jpg B000VRDIA6.pt01.jpg 10040.jpg B000BQ7UW4.pt01.jpg ren 10040.jpg B000BQ7UW4.pt01.j