File Renaming

[Ed in Aus]

I am trying to macro a painful process of renaming around 30 files from something like filename.csv to filename pay 21 07/08.csv help please this is painfully slow to do manually

 

[Ed in Aus]

Hey Suzie,

I might be able to help out, can you please show me the concatenate formula you tried to use?

Also can you provide an example of the file names you want to combine?

Hi Dan,

I am trying to have a list of PDF files renamed, there are thousands and renaming them manually is a pain.

So i tried to use the concatenate command but it still did not work.

Is there a way in Excel that we can do this if i have a list of my old file names and the new ones i want to rename it to ?

Could you please give me clear and simple instructions.

Thanks
Suzie

 

[Blade Hunter]

Hey Suzie, as Ed has indicated, can you post a copy of the concatenate you tried to do? It's probably easier for us to fix that. Alternatively just post the columns that your original name and new name are in and we can write it for you.

Cheers

Dan

 

[njimack]

The file in the link that I posted works for all type of files, pdf included.