CONTAINS

Returns a Boolean value (TRUE or FALSE) which determines whether a string expression is included in another.

Syntax

CONTAINS(text1, text2)

text1 - string expression (or the reference to a cells) being searched.
text2 - string expression (or the reference to a cells) sought.

Examples

CONTAINS("123456", "56") returns TRUE
CONTAINS("abcdef", "hello") returns FALSE