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

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


"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