How To Rename Multiple Files Of A Folder In Excel?

Description
May be most of us are suffered with this problem that we need to rename multiple files in a folder, to rename the filenames one by one will make us crazy if there are hundreds or thousands files in that folder. Are there any good functions for us to deal with this task?
If there are multiple files that you want to rename, first, you can list the old file names in a column of worksheet, and then enter the new filenames that you want to replace with. To quickly list all files in worksheet, you can use the below tool to achieve your goal.


How to use:
There are 4 buttons on top of the sheet bewlo the Header.
1. Import files (Import any number of data)
2. Refresh file list (You can press Refresh button to update the list)
3. Reset (it will reset the all table)
4. Rename Files (Though this button your file name will changed) 


Press "Import Files" button to import your file names into the below table that will be exapnd according to the number of data/files you have.


There is 1 more small table right below the buttons with five rows with below names:
1. File Path (Your file path will automatically loaded in to this line)
2. Replace What (Put here a specfic values that you are looking to replace)
3. Replace with (Through this you can replace new specific value)
4. Prefix (A word, letter, or number that you want to add placed)
5. Suffix (This will be added to the end of the name)


When your data will be uploaded by going through all the above steps you can change your files name easily in single go.