Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Separate first and second name in one cell into separate cells.
My list has the first and last names in the same cell. How can I separate
these into two separate cells so I can sort by last name. Or is there a way to sort by the last name when the name in the cell is "firstname lastname"? |
#2
|
|||
|
|||
Hi Dwight
if you want to keep a copy of the combined names, copy this column to a new column before doing the following: insert a blank column to the right of the column with the combined names select the column of combined names choose data / text to columns ensure delimited is checked - NEXT untick tab, tick space FINISH -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Dwight in Georgia" <Dwight in wrote in message ... My list has the first and last names in the same cell. How can I separate these into two separate cells so I can sort by last name. Or is there a way to sort by the last name when the name in the cell is "firstname lastname"? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separate first and second name in one cell into separate cells.
"Dwight in Georgia" wrote: My list has the first and last names in the same cell. How can I separate these into two separate cells so I can sort by last name. Or is there a way to sort by the last name when the name in the cell is "firstname lastname"? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separate first and second name in one cell into separate cells.
Data / text to columns / Delimited / Tick 'space' as delimiter, and this
will put the data into 2 separate columns. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "MaloMan" wrote in message ... "Dwight in Georgia" wrote: My list has the first and last names in the same cell. How can I separate these into two separate cells so I can sort by last name. Or is there a way to sort by the last name when the name in the cell is "firstname lastname"? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|