Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i re-sort multiple worksheets into alphabetical order | Excel Discussion (Misc queries) | |||
sort names | Excel Discussion (Misc queries) | |||
numeric sort on one sheet, automatically sorts alphabetical on another? | Excel Discussion (Misc queries) | |||
Sort order in File Open dialogue box | Excel Discussion (Misc queries) | |||
How can I sort multiple months/years WITHOUT Alpha order taking o. | Excel Worksheet Functions |