I have a folder with a file named:
'template.xlsx', and hundreds of files named:
old_2301 Item 1.xlsx
old_2014 Item 2.xlsx
old_5321 Item 3.xlsx
old_3212 Item 200.xlsx
I want to copy the file
template.xksx and create 200 new files:
2301 Item 1.xlsx
2014 Item 2.xlsx
5321 Item 3.xlsx
3212 Item 200.xlsx
I've tried something like:
In the folder, type Shift+Right shift: select "open command-window here"
for %a in (*.*) do copy "template.xlsx" ... ren ...?
I want to rename the copied
template.xlsx files to the same name as the other files, but with
old_ trimmed away.
Is there a simple way to do this?