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