REGEXMATCH

Whether a piece of text matches a regular expression.

Sample Usage

REGEXMATCH("Spreadsheets", "S.r")

Syntax

REGEXMATCH(text, regular_expression)

  • text - The text to be tested against the regular expression.

  • regular_expression - The regular expression to test the text against.

Notes

  • 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. TRUE or FALSE, as output. If numbers are used as input, convert them to text using the TEXT function.

See Also

REGEXEXTRACT: Extracts the first 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.

Examples

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
1811515823736184160
true
Search Help Center
true
true
true
true
true
35
false
false