Separate first and second name in one cell into separate cells.
Hi-light the column.
Data - Text to Columns...
Answer the resulting wizard
--
Gary's Student
"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"?
|