Contains()

Home   Back   Next  

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