Contains()

Working with Formulas > Functions Used in Formulas > Text Functions > Contains()

CONTAINS() searches for the search string in the other string. If the search string is found in the other string, CONTAINS() returns true, otherwise it returns false.

Function Format

CONTAINS(string, search string) 

Return Value

CONTAINS() returns a Boolean value 

Examples

CONTAINS("Green apples taste better than red apples.", "apples") = TRUE 

CONTAINS("Green apples taste better than red apples.", "oranges") = FALSE