Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Cam any one help me PLEASE!! I'am trying to sort a list of names in excel and
can not do it because I want to sort in last name order. I'm not that familiar with formulas so can anyone help a lady in distress? Thanks -- Adriana |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
What does your data look like? Are the last names in a cell of their own?
do you have 1st names and last names in one cell? We need as bit more info. "amolano8" wrote: Cam any one help me PLEASE!! I'am trying to sort a list of names in excel and can not do it because I want to sort in last name order. I'm not that familiar with formulas so can anyone help a lady in distress? Thanks -- Adriana |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
if you have the names in this format (First Last) try Data/Text to Columns.
Use a space as a Delimiter. Thsi will separate the first and last name into separate columns. It will work as long as there is one first name, no middle initial, and a single last name (all th esame). in other words, if there are more "spaces" in a name field, then it will create an additional column for that person. However, the few that might not be the same might be an easy edit. You can leave the names spearated and sort by last name, or use a helper column and the OCNATENATE function to form them back into one cell with the "last, First" state for sorting. "amolano8" wrote: Cam any one help me PLEASE!! I'am trying to sort a list of names in excel and can not do it because I want to sort in last name order. I'm not that familiar with formulas so can anyone help a lady in distress? Thanks -- Adriana |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sort Data Into Numerical Order..! | Excel Discussion (Misc queries) | |||
how do I set up a excel spreadsheet to auto sort data in order | Excel Discussion (Misc queries) | |||
Sort order in File Open dialogue box | Excel Discussion (Misc queries) | |||
sort rows in alphabetical order and move the corresponding data | Excel Worksheet Functions | |||
sort worksheets in numerical order | Excel Discussion (Misc queries) |