I have 2 files with thousands of names and need to manipulate the format of the names so that they match. Is there a formula I can use to make the names in one file formatted like the other? Thank you!

File 1:

Smith,John E
Johnson,Ashley T
Loeb,Steve K

File 2:

John Smith
Ashley Johnson
Steve Loeb