How to Use Does Not Contain in the Formula Builder

Goal

Determine if strings exclude specific characters. 

Learn

You can either use NOT(CONTAINS) or NOT(CONTAINS_IC), depending on whether you need the results to be case sensitive. You can also use a bang (!) character to specify NOT.

Example

!CONTAINS(#Sheet1!myString; “value”)
Column 1 String !CONTAINS returns
United States "united" TRUE
United States "States" FALSE
Germany "Germany" FALSE
United Kingdom "kingdom" TRUE