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 





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


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