Ok i have a spreadsheet with names

[Guest]

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

 

[SteveF]

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

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