I'm trying to use the Find function to determine the presence or absence of a substring in a text cell. When I use =FIND("string",B21)>0, I get TRUE if the string is found and a #value error if not. In this example, cell B21 is a text cell. Excel's help is useless in this case. Can someone clue me in about what I'm doing wrong?

1 Answer

"Excel's help is useless in this case" - I don't think so. It clearly states that return value is error when sought string couldn't be found.

Use
=IFERROR(FIND(...)>0,FALSE)

7

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy