Problem:
Converting the full names in column A, formatted \"LastName, FirstName\" into names formatted \"FirstName LastName\".
Solution:
Use the RIGHT, LEFT, LEN and FIND text category functions, as follows:
=RIGHT(A2,LEN(A2)-FIND(\"\",\"\",A2)-1)&\"\" \"\"&LEFT(A2,FIND(\"\",\"\",A2)-1)
Example:
Full Name_________Result
Seinfeld, Jerry___Jerry Seinfeld
Bush, George______George Bush
Jordan, Michael___Michael Jordan
Bowie, David______David Bowie
Bookmarks