Hi gang. I searched posts and was unable to locate this question. Any help pointing me in the right direction would be greatly appreciated!

I have two client spreadsheets with an extensive number of names that I need to compare. I would like to change the name format on one spread sheet from LastName, FirstName to FirstName LastName. probably pretty self-explanatory but Smith, John to John Smith.

Is there any way to do this automatically for an entire column?