Reversing Strings Based On Specific Characters.

This doesn't work

And you must change some commas like the following:
=RIGHT(A2;LEN(A2)-FIND(",";A2)-1) & " " & LEFT(A2;FIND(",";A2)-1)

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

I just removed the double quotes within the FIND function and it worked fine - like so =RIGHT(A2,LEN(A2)-FIND(",",A2)-1)&" "&LEFT(A2,FIND(",",A2)-1)

Data > Text to Columns, then make sure both space and comma are checked. To reverse the columns you can cut and paste.

A formula approach......

with "Bush, George" in A1 use this formula in B1

=TRIM(REPLACE(A1,1,FIND(",",A1&","),""))

and in C1

=LEFT(A1,FIND(",",A1&",")-1)

Ok, say the names are in cells A1:A10. Highlight these cells, then from the menu select Data, then Text to Columns. This will bring up the Convert Text to Columns Wizard.

Select Delimited, then click Next.

Make sure both "Space" and "Comma" check boxes are checked, then click Finish.

What this will do is put the last names in cells A1:A10 and first names in cells B1:B10. If you want them in reverse order, you can simply cut and paste the cells to where you would like them.

How can the formula be adjusted if the name read:


Smith, Brian A.


TIA, Laura

Originally Posted by lradon

How can the formula be adjusted if the name read:


Smith, Brian A.


TIA, Laura

Assuming the name is in A1,

B1 (first name):

Please Login or Register  to view this content.

C1 (middle initial):

Please Login or Register  to view this content.

D1 (last name):

Please Login or Register  to view this content.

I will try it!!