Sorting list of names

  • Thread starter Thread starter Phyllis
  • Start date Start date
P

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?
 
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
 
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.
 
Back
Top