FUNCTION CATALOGUE / TEXT
REGEXEXTRACT Excel function
Extracts text matching a regular expression in supported Microsoft 365 versions.
Correct sentence to use
Extract text matching [regex] from [text].
Modify this query in PlainFormula →Example formula
=REGEXEXTRACT(A2,"[0-9]+")
Extracts a regex match where supported.
Syntax
REGEXEXTRACT(text, pattern, [return_mode], [case_sensitivity])
Argument signature: text, pattern, [return_mode], [case_sensitivity]
Availability note
Microsoft 365 builds that include this function; check update channel and platform.