REGEXEXTRACT
extracts the first regex match · from excel · excel: not yet compared · sheets: not yet compared
signature
REGEXEXTRACT(text, pattern, [return_mode])
returns: text
| argument | required |
|---|---|
| text | required |
| pattern | required |
| return_mode | optional |
examples
formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.
fx
=REGEXEXTRACT("text", "text") text errors
error values observed from the engine — each with a call that produces it.
| error | produced by |
|---|---|
| #N/A | =REGEXEXTRACT("alpha", 2) |