Reformatting Last Name, First Name in Excel 2010

I know there is a formula for this, but I can't locate it.  I have a spreadsheet with names in column A, in Last Name, First Name format.  I want them in First Name Last Name format.  How do I do that, please?
Who is Participating?
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
=IFERROR(TRIM(MID(A1,FIND(",",A1)+1,999)) & " " & TRIM(LEFT(A1,FIND(",",A1)-1)),A1)
=MID(A1&" "&A1,FIND(" ",A1)+1,LEN(A1))
gsfcAuthor Commented:
Thank you very much for your prompt and accurate response.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.