REGEXTEST
Determines whether any part of text matches a regular expression pattern
Syntax
REGEXTEST(text, pattern, [case_sensitivity])
Parameters
- text: Required. The text to test against the pattern
- pattern: Required. The regular expression pattern
- case_sensitivity: Optional. 0=case-sensitive (default), 1=case-insensitive
Example
=REGEXTEST("Hello World", "[Hh]ello")