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.
Get the latest Excel tips and tricks by joining the newsletter!
Andrew Roberts has been solving business problems with Microsoft Excel for over a decade. Excel Tactics is dedicated to helping you master it. You can read more of his writing on his personal blog at NapkinMath.io.
Join the newsletter to stay on top of the latest articles. Sign up and you'll get a free guide with 10 time-saving keyboard shortcuts!