| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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"? |
Threaded Mode
