This is the formula you provided to extract the last word form a text string to another cell: =MID(A1,SEARCH("^^",SUBSTITUTE(A1," ","^^",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,LEN(A1))
The problem is that I need it to extract (remove) the word form the end of the text string and insert it into the new cell. This is not happening with this formula.
Solved by T. F. in 28 mins