deepcalc
DocsREGEXMATCH

REGEXMATCH

View as markdown/docs/functions/regexmatch.md Ask Claude about this pageOpens Claude with this page's address

True when text matches a regular expression.

  • Excel: No equivalent
  • Google Sheets: Not checked yet
  • Returns: Boolean

Examples

=REGEXMATCH("deepcalc", "^deep")
Result true

Syntax

REGEXMATCH(text, regular_expression)
text
text required
regular_expression
text required
ASCConverts full-width characters to half-width. BAHTTEXTSpells a number as thai baht and satang. CHARReturns the character for a character-set code. CLEANRemoves non-printable characters. CODENumeric code of the first character. CONCATJoins multiple text strings into one.