Excel2003 use rename command ren combine batch to implement batch modify file name

A lot of novice friends have encountered such a problem is how to batch process change file name? You may not find a rename command ren in Excel, use it to quickly complete the batch file name, there is a good tutorial, you can try to operate under.

Description: Changes the file name in the specified folder in bulk, and add numbers to it, such as 1-,2-, assuming that the specified folder is a, contains several files and subfolders, first the file number in folder A, and then the file number in subfolder B, subfolder B still contains subfolders and files, The numbering method is the same as a but the serial number of a, for example, there are 3 files in a, then the file in B starts from 4

Solution: You can use the "spirit of the name change" to solve

1. Use the "filter" plate to traverse all target files

2, using the "incremental" plate named 1-, 2-such a format

3. To menu "list"-"Import Export"-"Excel" to export a list to an Excel workbook

Specific steps

1, first start the computer Excel, I tell you examples, just create a relatively simple table, in the C2 cell input formula: = "ren" &A2& ". jpg" &B2& ". jpg", this is a word linked formula, Indicates that the contents of the cell A2 is renamed to B2 Cell, the carriage return gets the result, and the cell fills the entire table.

2, copy the contents of column C, excluding the title, paste into a Notepad, save type selected for all types, and then save as a bat file.

3, the bat file with the need to replace the name of the file, the same folder, double-click the execution can be.

For some of the names of the rules of the file batch modified to a certain pattern of documents, can be simpler, CTRL + a all selected files, right click Rename, after the first file name, such as green tea, the subsequent file will automatically become green tea (1), green tea (2), green tea (3), green tea (4) and so on, The serial number according to your name successively to decide.