| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
alphabetize names
I need to alphabetize names in a column automatically? Is that possible?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
alphabetize names
Brendar
Could you give an example? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "brendar" wrote in message ... I need to alphabetize names in a column automatically? Is that possible? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
alphabetize names
Perhaps have a look in help index for SORT. Or, more info.
-- Don Guillett SalesAid Software "brendar" wrote in message ... I need to alphabetize names in a column automatically? Is that possible? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
alphabetize names
IF you have names in the format <forename family name AND you need to sort
by family name you'll need a helper column for the family name element. To do this- insert a column immediately to the right of the name column highlight the name column Click on <Data<Text to columns<Next<Space<Next<Finish Regards. Bill Ridgeway Computer Solutions "brendar" wrote in message ... I need to alphabetize names in a column automatically? Is that possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I alphabetize sheet tab names? | Excel Discussion (Misc queries) | |||
| Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
| Can excel alphabetize a list of names? | Excel Worksheet Functions | |||
| Convert Local Names to Global Names | Excel Worksheet Functions | |||
| sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) | |||
Linear Mode
