How can I perform a reverse string search in Excel?

We know in Excel when we want to do search for a string, we use the ‘=SEARCH’ function call. But what if you want to do a reverse string search? Unfortunately, Excel doesn’t have a function to do this but you still can accomplish this by using the following command that was found on the web.

=IF(ISERROR(FIND(” “,A1)),A1, RIGHT(A1,LEN(A1) – FIND(“|”,
SUBSTITUTE(A1,” “,”|”,LEN(A1)-LEN(SUBSTITUTE(A1,” “,””))))))

The above formula will do a reverse search for the backspace.