Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
how i can aarange names in alphabetical odders
|
#2
|
|||
|
|||
I assume you mean that you first and surnames in a cell and you want to sort
on surnames. You will need to extract the surname into a separate helper column, using MID and FIND functions (an example assuming names like John Smith, =MID(A1,FIND(" ",A1)+1,99), and then sort both columns on the surname column. -- HTH RP (remove nothere from the email address if mailing direct) "ADNAN" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) | |||
Tab Names II | Excel Discussion (Misc queries) | |||
how can I count distinct names in an excel list? | Excel Discussion (Misc queries) | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
How can I find the common names in two columns of names? | Excel Discussion (Misc queries) |