Strip out numbers from file names in a directory.
Greetings,
I have a bunch of Word files in a directory with names like this one:
46468-1448197 - Smith-Bob-Sep 12, 2021 220 PM
The file names have a consistent pattern throughout. Each begins with a hyphenated serial number(?) with the same number of digits, followed by a space, followed by a hyphen, followed by a space. Beats me why the source of these files would name them that way, but that was not my call.
I want to run a macro that truncates the names of all files within a selected directory up to and including the " - ", so that what is left is merely:
Smith-Bob-Sep 12, 2021 220 PM
I looked for and noticed bits and pieces of code that provide a partial solution but I cannot piece it together.
Your kind help is much appreciated.
Jim.
|