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