SUBSTITUTE

Syntax

=SUBSTITUTE(text; old_text; new_text; [instance_num])

Description

Substitutes new text for old text in a text string.

Related Functions