View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jackie
 
Posts: n/a
Default 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