Customizing the Reverse String Search Formula
The full reverse string search formula is as follows:
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.