How to Do a Reverse String Search in Excel Using FIND

Customizing the Reverse String Search Formula

The full reverse string search formula is as follows:

=IF(ISERROR(FIND("X",A1)),A1,RIGHT(A1,LEN(A1)-
FIND("~",SUBSTITUTE(A1,"X","~",LEN(A1)-LEN(SUBSTITUTE(A1,"X",""))))))

To customize the formula to your uses, replace the red X‘s with the search value. Make sure the green tilde (~) does not appear anywhere in your string, or change it to a character that definitely won’t appear if you are unsure. Finally, change the references to cell A1 in blue to the cell that contains the string you want to search inside.