Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Cells in Alphabetical Order by Last Name
I have a file that was sent to me and the person wants to sort it by last
name. The problem is that the names were typed in one cell, for example "Ken T. Jones" or sometimes "Kenneth Jones" - is there a way in Excel 2003 that you can tell it to sort by the last name in a cell? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Cells in Alphabetical Order by Last Name
Say the names are in column A. In a helper column enter:
=MID(A1,FIND("~",SUBSTITUTE(A1," ","~",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,255) and copy down. This yield the last name. Sort both columns by the helper column. -- Gary''s Student - gsnu200750 "Maureen115" wrote: I have a file that was sent to me and the person wants to sort it by last name. The problem is that the names were typed in one cell, for example "Ken T. Jones" or sometimes "Kenneth Jones" - is there a way in Excel 2003 that you can tell it to sort by the last name in a cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colors and alphabetical order | Excel Discussion (Misc queries) | |||
Alphabetical order possible? or not | Excel Discussion (Misc queries) | |||
How do I put worksheets in alphabetical order | New Users to Excel | |||
How do I put worksheets in alphabetical order | Excel Worksheet Functions | |||
sorting letters in words into alphabetical order | Excel Discussion (Misc queries) |