sort last names by in alphabetical order
 

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

sort last names by in alphabetical order
 

Regardless you need to extract the last name either with a formula or
datatext 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


"Jackie" wrote:

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