Hello,
I have hundreds of files in the same file path and I need to mass update the file name. I can create a spreadsheet of two columns, "Current Name" and "New name".
Is there a way to have excel do this for me?
Thank you,
Hello,
I have hundreds of files in the same file path and I need to mass update the file name. I can create a spreadsheet of two columns, "Current Name" and "New name".
Is there a way to have excel do this for me?
Thank you,
try the code in the post #1 https://www.excelforum.com/excel-pro...haracters.html
Assumes headers in top row, old file name in Column A, new file name in Column B
Columns A & B have file names without path but with file extensions
Change references as required.
Do you want code to output all the existing file names in the folder to Column A?Please Login or Register to view this content.
And what about the new names?
This might be interesting.
https://www.publicspace.net/windows/BetterFileRename/
Last edited by jolivanes; 03-20-2023 at 01:13 AM.
Experience trumps academics every day of the week and twice on Sunday.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks