Quote Originally Posted by tigeravatar View Post
=IF(ISNUMBER(FIND(" ",A1)),TRIM(SUBSTITUTE(A1,TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",255)),255)),"")),A1)
Perhaps not very likely but this might not work correctly if the last "word" is repeated, e.g. if A1 is "dog cat dog" then the formula returns just "cat". Perhaps try this version

=IF(COUNTIF(A1,"* *"),MID(A1,1,LOOKUP(2^15,FIND(" ",A1,ROW(INDIRECT("1:"&LEN(A1)))))),A1)