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