If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sorting by multiple names in excel
Hi Scotty
Easiest option is to use the Data / Text to Columns feature to separate the names (delimited & space as the character) Select the column with the names in it - ensure that there's a blank column to the right, choose Data / Text to Columns Choose delimited click next untick tab & tick space click finish you now have the names in two columns if you want to put them back into one column after the sort in a third column type =A1 & " " & B1 where A1 is the first name & B1 is the surname this formula can be filled down for all the rows (you'll then need to select the column, copy it & edit / paste special - values to turn it from a formula into the actual name) hope this helps Cheers julieD "Scotty McExcellent" wrote in message om... Here's the problem I have. We receive word documents with names (first, last). Is there a way to dump these names into Excel and sort by the last name? Or is there a way to paste the names into seperate cells? Example (1 cell): Katie Mac Stewie Long Dan Agerert Sorted to: Dan Agerert Katie Mac Stewie Long |
#2
|
|||
|
|||
Sorting by multiple names in excel
Hi
Once they are in Excel, use Data / Text to columns to split the first name from the last and then you can sort as you wish. BTW, it looks like your 'Sorted to:' list is sorted on first name! 8) -- Andy. "Scotty McExcellent" wrote in message om... Here's the problem I have. We receive word documents with names (first, last). Is there a way to dump these names into Excel and sort by the last name? Or is there a way to paste the names into seperate cells? Example (1 cell): Katie Mac Stewie Long Dan Agerert Sorted to: Dan Agerert Katie Mac Stewie Long |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
DoCmd.OutputTo into multiple worksheets in excel | marcus. | Running & Setting Up Queries | 1 | June 2nd, 2004 10:14 AM |
Multiple Many-To-Many Tables | Tom | Database Design | 7 | May 15th, 2004 03:47 AM |
Excel Multiple opening | Ron_A | Setting up and Configuration | 1 | February 7th, 2004 02:51 AM |
Multiple Criteria (Excel: SUMIF vs. SUMPRODUCT) | Cecilia | Worksheet Functions | 3 | January 23rd, 2004 07:25 PM |
Multiple Instances of Excel opening | Carolyn | Setting up and Configuration | 1 | September 19th, 2003 02:13 AM |