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