Sorting Data

[Guest]

Does anyone know how to sort a column with a second word inside a cell?

 

[RagDyer]

Create a "helper" column to extract the word(s) of interest.
Then, sort on the helper column.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Does anyone know how to sort a column with a second word inside a cell?

 

[Guest]

What function is the one I use to extract the 2nd word? Thanks for your help!!

 

[RagDyer]

Give some examples that would be symbolic of your data.
Be as explicit as possible.
--


Regards,

RD

 

[Dave Peterson]

Are the words separated by spaces?

If yes:

=MID(A1,FIND(" ",TRIM(A1))+1,FIND(" ",TRIM(A1),
FIND(" ",TRIM(A1))+1)-FIND(" ",TRIM(A1))-1)

(all one cell).

Or you could use a couple of helper cells.

I inserted new columns B, C and D and use this:

In B1:
=FIND(" ",TRIM(A1))

In C1:
=FIND(" ",TRIM(A1),B1+1)

In D1:
=MID(A1,B1+1,C1-B1-1)

(in fact, all I did to get the long formula is to look at D1 and replace both
the
B1's with the formula in B1.

Then replaced the C1 with that formula in C1.

===
I find the helper cells easier to build and understand (and easier to debug).