REGEXEXTRACT
Extracts strings within the provided text that matches the pattern.
TextModern Excel FunctionsText Processing
What it does
Matches and returns substrings using regular expressions.
Syntax
REGEXEXTRACT(text, pattern, [return_mode], [case_sensitivity])
Arguments
text(text) — Source text.pattern(text) — Regex pattern.
Examples
Extract Digits
Get number from text.
FORMULA
=REGEXEXTRACT("Item 123", "\d+")RESULT
123
SAMPLE DATA
| A | |
|---|---|
| 1 | Text |
| 2 | Item 123 |