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 |
Comments
0 comments
Please sign in to leave a comment.