Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Save your data first, and make sure there is a blank column (or two) to the
right of the column with your data in it........then Highlight the column of names..........then Data Text to columns delimited next check "space" for a delimiter next finish...... Vaya con Dios, Chuck, CABGx3 "crc-src" wrote in message ... I have a spreadsheet with first and last names in one cell. I would like to sort by last names. Is there any way to sort by the second word in a cell or a quick way to divide the cell by first and last names, without cut and paste? |
#2
|
|||
|
|||
how do i sort by second word in a cell?
I have a spreadsheet with first and last names in one cell. I would like to
sort by last names. Is there any way to sort by the second word in a cell or a quick way to divide the cell by first and last names, without cut and paste? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Can not see all of a pasted paragraph from Word in a cell. | Excel Discussion (Misc queries) | |||
Copy Word table into Excel cell by cell | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |