CONTAINS()

Does text contain fragment?

Returns a Yes/No expression, as follows:

  • TRUE if the text fragment is found in the search value.
  • FALSE if the text fragment is not found in the search value.

Note: The search is case-insensitive: upper- and lower-case letters are equivalent.

Sample usage

CONTAINS("abc", "a") returns  TRUE

CONTAINS("abc", "bc") returns TRUE

CONTAINS("abc", "d") returns FALSE

CONTAINS("I'm bored!", "Red")  returns TRUE

CONTAINS([Address], "PO Box") answers the question: does the Address indicate a post office box?

CONTAINS([Email], "@") answers the question: does the Email contain at least one at sign (@)?

CONTAINS(".?!", LEFT([Sentence], 1)) answers the question: is the left-most character of the value of the Sentence (LEFT([Sentence], 1)) a period (.), question mark (?), or exclamation mark (!) (".?!")? Equivalent to IN(LEFT([Sentence], 1), {".", "?", "!"}).

See also: LEFT(), IN()

Syntax

CONTAINS(text-to-search, text-to-search-for)

  • text-to-search - Text to be searched.
  • text-to-search-for - Text string to search for in text-to-search.

See also

ENDSWITH()

FIND()

IN()

STARTSWITH()

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
4443781900763271560
true
Search Help Center
true
true
true
false
false