Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sorting
I have a column of names with last name first. I want to have Excel sort
these so that the FIRST name is first. Can this be done? |
#2
|
|||
|
|||
You'll need to pull the first names into a different column. While you can
do that with formulas, it is usually faster & easier to insert two new columns, copy & paste the names into the left new column, and then use Data|Text to Columns on that copied data, splitting the names where there's a comma or space, depending on how the list is set up. "Patrick" wrote: I have a column of names with last name first. I want to have Excel sort these so that the FIRST name is first. Can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Sorting 1, 1A, 2, 2A, 3, 4, 4A, 4B . . . | Excel Discussion (Misc queries) | |||
sorting number in ascending order | Excel Discussion (Misc queries) | |||
SORTING question | New Users to Excel | |||
Adding a KeyID column for sorting | New Users to Excel |