FUNCTION CATALOGUE / TEXT
SUBSTITUTE Excel function
Replaces matching text.
Correct sentence to use
Replace [old text] with [new text] in [text].
Modify this query in PlainFormula →Example formula
=SUBSTITUTE(A2,"old","new")
Replaces matching text.
Syntax
SUBSTITUTE(text, old_text, new_text, [instance_num])
Argument signature: text, old_text, new_text, [instance_num]
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.