Select the E column and paste this as text to an text file:Ĭode: Select all AVI name.avi|SRTname.avi In Excel write this command into column E and paste it down the columnĪVI name.avi | SRTname. avi into column D and paste it down the column Select All and use context menu > copy to clipboard Name (without Ext) In Excel column B cell 1 write an pipe symbol |Īnd use Excel to copy it in all cells down the B column Open Excel and paste this list to column A Select All and use context menu > copy to clipboard Name + Ext (EDIT: see the link at the end to see an picture how this looks in excel) Please read an step-by-step explanation for the above challenge, for other issues you may skip some steps. Then use the excel options to copy that formula down all lines. The basic syntax in excel therefor is in column (C1) '= A1 & '|' & B1' Then merging that two columns and add an pipe-symbol '|' as delimiter. Having the old name in one column (A1), and the new name in an another (B1), The idea of this post is to use excel to create such an text file.

If the file is valid then you will see the 'new name'Ĭolumn reflecting the contents of the text file. Next, click the Import option on the File menu and load your file.

To use this facility, create a text file in for the correct format, for example:

Bulk rename utility example