How to modify file names in batches

Procedure

• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8

When using computer and network writing experience, we often need to download some images from the Internet for matching, while the file name on the network is strange, we need to number the image files in order. Therefore, you need to modify file names in batches. We will share this experience with you below.

Tools/Raw Materials

• Have basic computer operations and workbooks

• Computer (XP operating system), installed with xls

Method/step

2. Create a folder on drive C and place the downloaded images in the folder, as shown in.

4. Click the left mouse button to start-run-enter the letter "cmd" in the dialog box to enter the DOS mode, as shown in.

6. In DOS mode, enter the command line "cd c: \ pic" and press Enter. Then, enter the command line "DIR/B> rename.xls". As shown, the file names in the folder can be listed in the rename.xls file.

   Tip: Sometimes your computer is in the Chinese Input State. To ensure that the command line can be typed, you can switch to the English uppercase state.

8. Then open c: \ users with XLS as the first file name.

10. Move the mouse to select cell B1, and at the bottom right of column B1, change the mouse cursor to +, drag to make all JPG files have file names in column B on the right. Delete unused file names in cell A8, as shown in.

12. Select cell C1 and enter the formula = "Ren" & A1 & "& B1 in the edit box, as shown in.

14. Continue dragging the handle at the bottom right of cell C1 to fill the remaining C2-C7 cells, as shown in.

16. Select column C and right-click it to copy, as shown in.

18. Paste the command line in notepad, as shown in.

20. Click "file"> "Save as" in the menu and enter the file name "Ren. Bat". Note the path and extension options in red circles.

22. Modify the sequence and file name in batch in sequence, as shown in.

24. Since then, you have completed the batch modification of file names. We use doscommand, xls, and batch processing to modify file names in batches.

Notes

• This experience requires a certain degree of knowledge about DOS and computer operations. If you have mastered the basics of XLS function formulas, you can perform better processing of batch file names.

  http://jingyan.baidu.com/article/656db918a7e848e381249c0e.html