I have a column that contains a long comment field.
I want a formula to tell me if a given set of characters exists in the comment field.
I don't care *where* the substring occurs, just does it occur, true or false.
Unfortunately the FIND function returns #VALUE! if the substring is not found.
Is there a way to "translate" the error value to a zero?
I want a formula to tell me if a given set of characters exists in the comment field.
I don't care *where* the substring occurs, just does it occur, true or false.
Unfortunately the FIND function returns #VALUE! if the substring is not found.
Is there a way to "translate" the error value to a zero?