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"? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|