Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I isolate the last two words in a text string?
I have found a formula that works great for retrieving the last word from a
string of charactors in a cell. If the string in Cell A1 is: "How do I return the last two words?", the formula below will give me the last word. (Isn't it nice sometimes to have the last word?) {=RIGHT(A1,MATCH(" ",MID(A1,LEN(A1)-ROW(INDIRECT("1:"&LEN(A1))),1),0))} This will return "words?". How can I modify this or, what other formula will return, "two words?". I think this is a very slick formula, but I don't quite understand it well enough to figure out how to modify the match to find the second blank. Note: I found this formula in Osborne, THE COMPLETE REFERENCE EXCEL 2000 by Kathy Ivens and Conrad Carlberg. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
isolate date from a text string into another cell | Excel Discussion (Misc queries) | |||
Extracting the last set of words from a text string | Excel Worksheet Functions | |||
How do I do a multiple search using key words in a text string | Excel Discussion (Misc queries) | |||
Alphabetically reorder a text string with multiple words | Excel Worksheet Functions | |||
Alphabetically reorder a text string with multiple words | Excel Worksheet Functions |