sorting using a second word in a cell
 

I was just wondering if there is a way to sort columns by using the second
word in a cell? and if so how would i go about it?

sorting using a second word in a cell
 

You would need to create a help column then use a formula to extract that
second word, then sort by the help column


--

Regards,

Peo Sjoblom





"sonia" wrote in message
...
I was just wondering if there is a way to sort columns by using the second
word in a cell? and if so how would i go about it?

sorting using a second word in a cell
 

Sonia,

In another column, put something like:

=MID(A2,FIND(" ",A2)+1,9999)
or less sloppy:
=RIGHT(A2,LEN(A2)-FIND(" ",A2))

It should yield the text in A2 without the first word. Sort on that column. This is for
where column A is the column on which you want to sort on the second word.

--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"sonia" wrote in message
...
I was just wondering if there is a way to sort columns by using the second
word in a cell? and if so how would i go about it?

sorting using a second word in a cell
 

Thanks Earl, that helped heaps

"Earl Kiosterud" wrote:

Sonia,

In another column, put something like:

=MID(A2,FIND(" ",A2)+1,9999)
or less sloppy:
=RIGHT(A2,LEN(A2)-FIND(" ",A2))

It should yield the text in A2 without the first word. Sort on that column. This is for
where column A is the column on which you want to sort on the second word.

--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"sonia" wrote in message
...
I was just wondering if there is a way to sort columns by using the second
word in a cell? and if so how would i go about it?