Formating First Name and Last Name

[Chico]

Change: LastName, FirstName

TO: FirstName LastName

Would like to do the formatting in one equation and one step.

 

[David Biddulph]

Data/ Text to Columns/ Delimited/ by comma

 

[Gary''s Student]

=RIGHT(A1,LEN(A1)-FIND(" ",A1)) & " " & LEFT(A1,FIND(",",A1))

Thus
Ravenswood, James
will become
Janes Ravenswood