Strip out numbers from file names in a directory.

[JustJim]

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.