I need a formula to use in Excel that will simply return TRUE if a certain subset exists within the text of a cell.
Say for example that cell A1 reads “BLAH BLAH BLAH” and I wanted to find out whether the string “AH BL” exists in that cell.
Is there a way to do that? FIND and SEARCH tell you where the string starts, but it assumes the substring has to be in the referenced cell and returns an error if it isn’t present. So, I either I need a formula to directly test it or some way of usefully using the error.
iserr is exactly what I was looking for. Thanks CookingWithGas!
I thought I had looked through that section of the functions but I guess I missed it. I was getting pretty frustrated and we all know that induces blindness.