REGEXTEST
Description
Checks if text within a string matches a specified regular expression pattern and returns TRUE if there is a match and FALSE if there is not. This function works the same as MS.REGEXTEST.
This function is useful for validating data against specific formatting rules or identifying strings that contain certain patterns.
Syntax
REGEXTEST(
text
, regex
, [ignore_case
]) - text: The text or cell reference containing the text you want to match against.
- regex: The regular expression that defines the pattern of text you want to match.
- ignore_case: If TRUE, the case of the text is ignored. If FALSE (default), the case is considered.