sort last names by in alphabetical order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can any one help
I have a list with several name.
Ex
John H.Smith
Joe R. Doe
Jackie John
How do I sort by last name without using TEXT to Column because I know how
to use that but my list is long and sometime the middle initials get caught

thanks
jackie
 
Regardless you need to extract the last name either with a formula or
data>text to columns, if it is always a space then the last name you can use

=MID(A1,FIND("^^",SUBSTITUTE(A1," ","^^",LEN(A1)-LEN(SUBSTITUTE(A1,"
",""))))+1,1024)


copy down, select both colums and sort by the help column


Regards,

Peo Sjoblom
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel: Sort alphabetically using the last word in a cell? 1
last name alphabetical order 3
Matching Names 5
How to sort names in alphabetical ascending order? 7
Auto Sort By Name 1
Sorting Cells in Alphabetical Order by Last Name 1
Sort in Greek alphabetical order 2
How do I separate first and last names into two columns? 2

Back
Top