Changing File Names in Excel Folder

Here you Go.
Run the first macro and it will pull the names as the previous one and will automatically type the new name in column C.

Then Run the other Macro to rename them.
Please Mark the thread as solved if it was.