Remove Commas & Middle Initial, Flip First and Last Name

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

Good day,

Use below code and drag below assuming your name is in cell A1

Please Login or Register  to view this content.

Press on the star icon if you like this post