Share via

Find text in string and return TRUE/FALSE

Anonymous
2012-07-23T14:41:05+00:00

I want to find text in a string, and return TRUE/FALSE. As far as i can tell, FIND and SEARCH will return an #VALUE! error if the text is not found, which means that I have to use a two-step approach, something like ISERROR(SEARCH(...)). That seems unnecessarily complicated. Is there a simpler way?

Thanks.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2012-07-23T14:45:25+00:00

    Surround your FIND or SEARCH with an IFERROR

    =IFERROR(FIND(......),FALSE)

    10+ people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-07-23T14:54:31+00:00

    Its new in versions 2007 onwards.

    0 comments
  2. Anonymous
    2012-07-23T14:53:15+00:00

    Thanks. I didn't know about the IFERROR function.

    0 comments