sorting using a second word in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You would need to create a help column then use a formula to extract that
second word, then sort by the help column
 
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...
 
Thanks Earl, that helped heaps

Earl Kiosterud said:
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...
Click to expand...
 
Back
Top