![]() ![]() Copy Paste the same formula across all cells in Column3, which have values in Column1 and column2. In column3, type the excel formula CONCATENATE(“(“ren “,A1, ” “, B1) and is ready to be executed.We will convert this into a DOS rename command. Source filenames containing in column1 and destination filenames are in column2.Using SUBSTITUTE function in Excel as SUBSTITUTE (A1,”Scenery”,”Image”) will change the name of the file from Scenery to Image. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |