For example, you have the following the text in a cell “A1”:
I want to extract the last two word in this cell
To extract the last two words in cell “A1″, use the following formula:
=MID(A1,FIND("@",SUBSTITUTE(A1," ","@",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))-1))+1,255)
Not working for you?
Remember to replace A1 with the cell that contains the string of words you want to parse out.