Home/Formulas/Text/REGEXMATCH
Textmedium

REGEXMATCH()

Returns TRUE if a piece of text matches a regular expression.

Syntax
fx
=REGEXMATCH(text, regular_expression)
Arguments
ArgumentDescription
textThe text to test against the regular expression.
regular_expressionThe RE2 regular expression to test for. Anchors and groups behave like Google's RE2 dialect.
Example
fx
=REGEXMATCH("abc123", "\d+")

Paste this into Google Sheets to run it. The live playground on this site covers 24 of the 61 functions, and REGEXMATCH isn't one of them yet.

Related formulas
REGEXEXTRACT()
Returns the first matching substring (or first capture group) of a regular expression.
REGEXREPLACE()
Replaces every match of a regular expression with the replacement text.
SEARCH()
Returns the position of a substring within a string. Case-insensitive.
Used by
FIND()
Returns the position of a substring within a string. Case-sensitive.
SEARCH()
Returns the position of a substring within a string. Case-insensitive.
REGEXEXTRACT()
Returns the first matching substring (or first capture group) of a regular expression.
REGEXREPLACE()
Replaces every match of a regular expression with the replacement text.
More Text formulas →Keyboard shortcuts for Sheets →