Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting names in a range
Just wondering if this is possible...
I have a range for names a1 - a10 I want to put name in the cells "firstname lastname" Is there a way to have the names put in the way specified and be able to sort them from the last name? Is there a way to check a string to a space? With the variable of the first name being different lengths, can you use the space after the first name as the marker to choose the next letter (the first letter of the last name) and use this to sort the names in the range? Or am I way off base and there might be an easier way. Thanks for any help. John |
#3
|
|||
|
|||
Hi
Such tasks are stong arguments to have all parts of name - firstname(s), lastname(s), title etc. in separate columns. You can always generate full name in any configuration from separate columns with a single formula, but there doesn't exist a general reversive solution. Sometimes people have a lot of first names, sometimes several last names, some people have a title (Von, Van, Don etc.) as apart of their name and some don't - so when you use formula like Ragdyer's one, you always have to check the result, and probably you have to edit the list manually. You can enter the full name in single cell only then, when you are absolutely sure you never have to use any part of it separately. -- When sending mail, use address arvil<attarkon.ee Arvi Laanemets "John S" <John wrote in message ... Just wondering if this is possible... I have a range for names a1 - a10 I want to put name in the cells "firstname lastname" Is there a way to have the names put in the way specified and be able to sort them from the last name? Is there a way to check a string to a space? With the variable of the first name being different lengths, can you use the space after the first name as the marker to choose the next letter (the first letter of the last name) and use this to sort the names in the range? Or am I way off base and there might be an easier way. Thanks for any help. John |
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) | |||
range names | Excel Worksheet Functions | |||
How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions | |||
range names | Excel Worksheet Functions | |||
range names | Excel Worksheet Functions |