If you are looking for software to use, go to Huajun Software Park! software release
Location: front pageTutorial strategyTutorialComputer software tutorials How about WinXP...

How to batch modify file names in WinXP? How to batch modify file names

Author: Five Horses Acacia Date: 2017-06-05

Method/steps:

1. Create a folder in the c drive and place the downloaded pictures in the folder, as shown in the figure below.

How to batch modify file names in WinXP? How to batch modify file names

2. Click the left mouse button, Start-"Run-" Enter the letters "cmd" in the dialog box to enter the dos mode, as shown in the figure below.

How to batch modify file names in WinXP? How to batch modify file names

3. In dos mode, enter the command line "cd c:pic" and press Enter, then enter the command line "dir /b》rename.xls", as shown in the figure below, you can change the file name in the folder to the rename.xls file listed in.

Tips: Sometimes, your computer is in Chinese input mode. To ensure that the command line can be typed, you can switch to English uppercase mode.

How to batch modify file names in WinXP? How to batch modify file names

4. Then use xls to open rename.xls in the c:pic folder. You will find that the file names are all listed in column A (you can also use the mouse to adjust the order of the file names). You can enter it in column B1. 1.jpg as the first file name.

How to batch modify file names in WinXP? How to batch modify file names

5. Select cell B1 with the mouse, and at the bottom right of column B1, when the mouse cursor changes to a + sign, drag so that all jpg files have file names in column B on the right. Then delete the unused file names in cell A8, as shown below.

How to batch modify file names in WinXP? How to batch modify file names

6. Select cell C1 with the mouse and enter the formula =”ren “&A1&” “&B1 in the edit box, as shown in the figure below.

How to batch modify file names in WinXP? How to batch modify file names

7. Continue to drag the handle on the lower right side of cell C1 with the mouse so that the remaining cells C2-C7 are filled as shown in the figure below.

How to batch modify file names in WinXP? How to batch modify file names

8. Then, select column C with the mouse and right-click to copy, as shown below.

How to batch modify file names in WinXP? How to batch modify file names

9. In Notepad, paste the command line just now, as shown below.

How to batch modify file names in WinXP? How to batch modify file names

10. Click the menu "File" - "Save As", enter the file name ren.bat, pay attention to the path and extension options in the red circle as shown in the figure below.

How to batch modify file names in WinXP? How to batch modify file names

11. Open the pic folder on drive c and double-click the batch file ren.bat to batch modify the file names of the jpg images in the folder according to the order and file names in rename.xls, as shown in the figure below.

How to batch modify file names in WinXP? How to batch modify file names

12. Since then, you have completed the batch modification of file names. We used three knowledge points of dos command skills, xls skills and batch processing to achieve the effect of batch modifying file names.

This is the detailed introduction to the method of batch modifying file names in WinXP. If you still don’t know how to batch modify file names, you can follow the above steps. This way you don’t have to modify them one by one. Isn’t it economical? A lot of time.

Related articles