Check whether a cell contains a substring

Question

Is there a built-in function that can determine whether a cell includes a specific character or substring?
When delimiting characters are absent, it would imply that you can use textual functions like Left/Right/Mid on a conditional basis without throwing issues.

Answer 1

Try using this:

=ISNUMBER(SEARCH("Some Text", A3))

This will return TRUE if cell A3 contains Some Text.