excel2003 ren command batch process modify file name method

How does Excel batch process modify file names? You can actually use a rename command ren in Excel to complete the batch file name. Below green tea Small series for everybody detailed demonstration under the operation step!

Excel2003ren commands combine batch to modify file names in batches

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.

Classification:

• Excel Tutorials