QUESTION

My cell contains last name, comma, first name. I need to switch it to First Name (space) Last Name.

ANSWER

=MID(A1,FIND(",",A1)+2,LEN(A1)-FIND(",",A1)) & " " & MID(A1,1,FIND(",",A1)-1)