Extract the Last Word from a Text String
The following formula extracts the last word from the text string in A2...
=REPLACE(" "&TRIM(A2),1,FIND("^^",SUBSTITUTE(" "&TRIM(A2)," ","^^",LEN(TRIM(A2))-LEN(SUBSTITUTE(TRIM(A2)," ",""))+1)),"")
Based on the sample data, the formula returns "string".
Sample Workbook: Download