# Last Name First

This is a discussion on Last Name First within the Excel Questions forums, part of the Question Forums category; I created a list of names in a column: John Smith Jane Doe John Doe Is there a way to ...

1. ## Last Name First

I created a list of names in a column:

John Smith
Jane Doe
John Doe

Is there a way to flip flop them to change the cell so that the last name is first:

Smith, John
Doe, Jane
Doe, John

2. ## Re: Last Name First

Hello and welcome to MrExcel.

Try this

Sheet5

 A B 1 John Smith Smith, John 2 Jane Doe Doe, Jane 3 John Doe Doe, John

Spreadsheet Formulas
 Cell Formula B1 =RIGHT(A1,LEN(A1)-FIND(" ",A1))&", "&LEFT(A1,FIND(" ",A1)-1)

Excel tables to the web - Excel Jeanie Html 4

3. ## Re: Last Name First

You are awesome! It worked. Thank you. That is a long formula. Just so I understand the formula, what does: LEN indicate

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

4. ## Re: Last Name First

LEN() returns the length (number of characters).

5. ## Re: Last Name First

You just saved me a lot of time. Thank you.

Have a good day!

6. ## Re: Last Name First

A bit shorter formula and not required the LEN function :

=MID(A1,FIND(" ",A1)+1,255)&", "&LEFT(A1,FIND(" ",A1)-1)

Regards
Bosco

7. ## Re: Last Name First

One complication of name-related formulas is that they don't take into account that some first names have 2 parts and some last names have 2 or more parts, so you may still have to manually adjust some of the results.

8. ## Re: Last Name First

But, this formula, I think may be the shortest :

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

Regards
Bosco

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•