FUNCTION CATALOGUE / TEXT
REGEXREPLACE Excel function
Replaces regex matches in supported Microsoft 365 versions.
Correct sentence to use
Replace matches of [regex] in [text] with [replacement].
Modify this query in PlainFormula →Example formula
=REGEXREPLACE(A2,"[0-9]+","")
Replaces regex matches where supported.
Syntax
REGEXREPLACE(text, pattern, replacement, [occurrence], [case_sensitivity])
Argument signature: text, pattern, replacement, [occurrence], [case_sensitivity]
Availability note
Microsoft 365 builds that include this function; check update channel and platform.