Whether a piece of text matches a regular expression.
text- The text to be tested against the regular expression.
regular_expression- The regular expression to test the text against.
- Google products use RE2 for regular expressions. Google Sheets supports RE2 except Unicode character class matching. Learn more on how to use RE2 expressions.
- This function only works with text (not numbers) as input and returns a logical value, i.e.
FALSE, as output. If numbers are used as input, convert them to text using the
REGEXEXTRACT: Extracts matching substrings according to a regular expression.
REGEXREPLACE: Replaces part of a text string with a different text string using regular expressions.
SUBSTITUTE: Replaces existing text with new text in a string.
REPLACE: Replaces part of a text string with a different text string.