Macro to transfer info from file names into cells?

[Legacy 73195]

Hi, I don't know if this is possible, but I find myself needing to cut and paste information from hundreds of Windows file names into different cells on a spreadsheet. For example, the info from a file named "3 - Doe, John 1234" needs to be transferred as such:

Column A: 3
Column B: Doe, John
Column C: 1234

with each file name populating a new row.

Anybody know if this is possible? Thank you!

 

[Legacy 73195]

Just bumping this thread -- I REALLY could use some help with this. Or at least if somebody smarter than me can tell me if this is even possible. Thank you!