Bulk Change Folder name method

Use DOS commands and Excel to complete
Add:
If your Excel worksheet is Sheet1, first click "Run" in the Start menu, enter "CMD", navigate to the folder where the picture is stored, and then enter Dir *. Jpg/b >tmp. BAT, when the folder is turned into a tmp bat file, right-click, select "Edit", all the contents of the selection, paste into Sheet2 A1 cell, Excel will automatically paste down the branch, in B2 cell input =vlookup (a1,sheet1! a:b,2,0) Enter, fill down, then Sheet2 B column will be corresponding to each test number to fill in the ID number, enter in C1 = "ren" &A1& "" &b1 Enter, fill down, then the C column will be populated with the format "Ren test number of ID number" Content, select all the contents of column C to copy, and then go back to TMP. BAT file , or right-click, edit , the contents of the inside all deleted, and then the Sheet2 in the C-column copy of the contents of the paste up, save, close, and then double-click Tmp.bat, renamed the completion

The first step, make a batch process, the file name in a folder (such as the photo name) is displayed in the spreadsheet. Copy the content between the lines below into Notepad and save as a batch file with the extension ". Bat":
-------------------------------------------------------------------
@echo off
echo Please close and put this batch file in the same folder as the photo ...
echo if it's already in the same folder as the photo, press any key to continue ...
@pause
@dir/b> lists the file name. xls "
--------------------------------------------------------------------
After the file name is listed, copy and paste it into the new spreadsheet for next steps.

Note: The file name listed with the extension, you can use "Find, replace" as "empty" way to remove the extension.

First-Find, enter the quotation marks (extension) ". jpg", then point-replace, then direct-replace all.

The second step, batch batch modified photo name:
In the Excel table, there are photo numbers and corresponding ID numbers and they correspond to the correct, using this table to the photo number named photos in bulk modified to the corresponding ID number.

Method One:

Cell A1 is the column heading "Photo Number", for example Picture001, in A2 cell;
Cell B1 is the column heading "Social Security Number", for example 412829199909018432, in cell B2;
Cell F3 is the photo extension ". jpg".
Cell C1 "Merge batch data" for the column header.
In cell C2, enter or copy the formula in the paste brackets:(= "REN" &A2&F$3& "&b2&f$3")

Description
"REN" means "renaming";
"&" means merge connection;
"f$3" means absolute reference to the 3rd row of data in column F.

Method Two:
You can not represent cell F3 for the extension. With formula: (= "REN" & "" &A2& ". jpg" & "&B2&". jpg ")

Enter or paste the original photo name (without the extension) into the cell A2 and below, and enter or paste the ID number into the cell B2 and below. In column C, drag the fill handle from the C2 cell to the desired row, copy the fill, and then copy the C column data and paste it into Notepad, Save as Ren.bat batch file to the folder (directory) where the photo is located, and double-click to run Ren.bat.

Copy and paste into Notepad in the format:

REN picture001.jpg 412829199909018432.jpg
REN picture002.jpg 412829199904108416.jpg
REN picture003.jpg 411528199902181050.jpg
REN picture004.jpg 412829199904108417.jpg
REN picture005.jpg 111721199907188433.jpg

Bulk Change Folder name method