Excel2003 How to Batch process file name modification

How does Excel batch process modify file names? You can actually use a rename command ren in Excel to complete the batch file name. Here is a detailed demonstration of the operation of the steps bar!

Excel2003ren commands combine batch to modify file names in batches

First, start the computer on the 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.

Step two, copy the contents of column C, excluding headings, paste into a Notepad, save type to all types, and then save as a bat file.

Step three, place the bat file in the file with the name you want to replace, and double-click it to execute the same folder.

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