Sorting list of names

[Phyllis]

I have a list of names that has the first and last name in
the same cell, with the first name appearing first. I
want to sort this list by the last name, how can I do this?

 

[Jason Morin]

Use a helper column that pulls out the last name:

=RIGHT(A1,LEN(A1)-FIND(" ",A1))

Select both columns and sort based on the helper column.

HTH
Jason
Atlanta, GA

 

[Phyllis Bogart]

Thank you. That's awesome. I've been using excel for
about 20 years now, and I never stop learning new things.
Thanks so much for your help.