Ok i have a spreadsheet with names

  • Thread starter Help me with this spreadsheet assignment
  • Start date
H

Help me with this spreadsheet assignment

I have a spreadsheet that I have their name this way first name last name,
when i click on assort by alphabet it does not put them in the right order.
So I want to switch it to last name, first name is there a way I can do this.

Example:

Susan Legler want it as Legler, Susan

Thank you Susan Legler
 
S

SteveF

Help said:
I have a spreadsheet that I have their name this way first name last name,
when i click on assort by alphabet it does not put them in the right order.
So I want to switch it to last name, first name is there a way I can do this.

Example:

Susan Legler want it as Legler, Susan

Thank you Susan Legler
Click to expand...

Assume your data is in Cell A1, put this formula in B1:
=RIGHT(A1,LEN(A1)-FIND(" ",A1))&","&LEFT(A1,FIND(" ",A1)-1)

Then sort by Column B

This only works if you data is in a consistent format as you have shown
it
 
Top