| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
last name alphabetical order
How do I get a list of First and Last names in a column to automatically be
put in alphabetical order by last name? Can you help please? A direct answer to would be greatly appreciated. Thanks again |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
last name alphabetical order
You need to parse out the last name. Create a helper column of just last
name using something like: =right(a1,len(a1)-find(" ",a1)) Regards, Fred "Reds0602" wrote in message ... How do I get a list of First and Last names in a column to automatically be put in alphabetical order by last name? Can you help please? A direct answer to would be greatly appreciated. Thanks again |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
last name alphabetical order
See example.
http://boisgontierjacques.free.fr/fi...iPrenomNom.xls JB http://boisgontierjacques.free.fr/ On 12 sep, 05:54, Reds0602 wrote: How do I get a list of First and Last names in a column to automatically be put in alphabetical order by last name? Can you help please? A direct answer to would be greatly appreciated. Thanks again |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
last name alphabetical order
Data/ Text to Columns will split your first and last names.
-- David Biddulph "Reds0602" wrote in message ... How do I get a list of First and Last names in a column to automatically be put in alphabetical order by last name? Can you help please? A direct answer to would be greatly appreciated. Thanks again |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
last name alphabetical order
Rob Bovey created a parsenames file years ago that still seems to work. Ask
him if he still has it for free? http://www.appspro.com/ -- Don Guillett Microsoft MVP Excel SalesAid Software "Reds0602" wrote in message ... How do I get a list of First and Last names in a column to automatically be put in alphabetical order by last name? Can you help please? A direct answer to would be greatly appreciated. Thanks again |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| alphabetical order in a colume | Excel Discussion (Misc queries) | |||
| sheets in alphabetical order | Excel Discussion (Misc queries) | |||
| Colors and alphabetical order | Excel Discussion (Misc queries) | |||
| Alphabetical order possible? or not | Excel Discussion (Misc queries) | |||
| why are my files out of alphabetical order? | Excel Discussion (Misc queries) | |||
Linear Mode
