In general, we search word from left side in a string, but would you ever tried to reverse search the word in a string, which means to quickly get the last word from string as below screenshot shown. Here, I introduce some formulas to help you quickly find the last word in a string in Excel sheet.
Reverse search to find last word in Excel
=RIGHT(A1,LEN(A1)-FIND(“|”,SUBSTITUTE(A1,” “,”|”,LEN(A1)-LEN(SUBSTITUTE(A1,” “,””)))))
=IF(ISERROR(FIND(” “,A1)),A1, RIGHT(A1,LEN(A1) – FIND(“|”,SUBSTITUTE(A1,” “,”|”,LEN(A1)-LEN(SUBSTITUTE(A1,” “,””))))))
Select a blank cell which you will place the search word, use one formula above, and press Enter key. Now the last words of the strings will be found.
