| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to copy the first word or two words from a cell containing a complete sentence to another cell | Excel Discussion (Misc queries) | |||
| How do a put a word on top of a word in a cell? | Excel Discussion (Misc queries) | |||
| Add word in cell changes to word TRUE | Excel Discussion (Misc queries) | |||
| how do I make a word typed in a cell go to a specific cell in anot | Excel Discussion (Misc queries) | |||
| Copy Word table into Excel cell by cell | Excel Discussion (Misc queries) | |||
Linear Mode
