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"?