deepcalc
DocsREGEXEXTRACT

REGEXEXTRACT

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

Extracts the first regex match.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Text

Examples

=REGEXEXTRACT("text", "text")
Result text

Syntax

REGEXEXTRACT(text, pattern, [return_mode])
text
text required
pattern
text required
return_mode
number optional

Errors

#N/A
=REGEXEXTRACT("alpha", 2)
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.