Syntax
=REGEXMATCH(text, regular_expression)Arguments
| Argument | Required | Description |
|---|---|---|
text | Required | The text to test |
regular_expression | Required | The regular expression |
How to use REGEXMATCH
REGEXMATCH takes 2 required arguments. Type =REGEXMATCH( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=REGEXMATCH("Spreadsheets", "S.*s")Result =REGEXMATCH("abc", "\d")Result Related text functions
- NUMBERVALUEConverts text to a number using the decimal and group separators you give, whatever the locale.
- PHONETICReturns the phonetic (furigana) text of a cell; here that is the text of the cell itself.
- PROPERCapitalizes the first letter of each word and makes the other letters lowercase.
- REGEXEXTRACTReturns the parts of a text that match a regular expression pattern.
- REGEXREPLACEReplaces the parts of a text that match a regular expression pattern.
- REGEXTESTChecks whether any part of a text matches a regular expression pattern.
- REPLACEReplaces part of a text, given a start position and a number of characters, with other text.
- REPLACEBSame as REPLACE, counting bytes; without a double byte language set as default each character counts as one byte.
- REPTRepeats text a given number of times.