Ok i have a spreadsheet with names

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

Help me with this spreadsheet assignment wrote:
> 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