The Reverse String Search Formula
The full syntax of the reverse string search formula is complicated and a bit confusing, so we will break down each part individually. First, though, let’s take a look at the full formula for cell A1 in our example.
=IF( ISERROR( FIND(" ",A1) ),A1,RIGHT(A1, LEN(A1)-FIND("~", SUBSTITUTE(A1," ","~", LEN(A1)-LEN(SUBSTITUTE(A1," ","")) ) ) ) )
You can select everything above and paste it into a cell to find the last word in the string in cell A1.