how do i sort by second word in a cell?

  • Thread starter Thread starter CLR
  • Start date Start date
C

CLR

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 said:
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
Click to expand...
paste?
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't format cells in data range 2
how to sort by last word in a cell? 2
Pivot Table won't Get 'r done 1
text to columns 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
sorting using a second word in a cell 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
sorting by first column then by second column 1

Back
Top