G
Guest
What is the best way to do the following:
500 excel files are in a folder. I need to rename each one as:
"lbif08" & first 5 digits of Cell A1 of each file &".xls"
Note: I don't need to keep the original file name.
Please help!!! Thank you!
500 excel files are in a folder. I need to rename each one as:
"lbif08" & first 5 digits of Cell A1 of each file &".xls"
Note: I don't need to keep the original file name.
Please help!!! Thank you!