The SUBSTITUTE function replaces a specific text string in a value. Case sensitive.

Formula in cell E3:


Excel Function Syntax

SUBSTITUTE(text, old_text, new_text, [instance_num])


text Required. The value you want to substitute text in.
old_text Required. The text string you are looking for in the value.
new_text Required. The text you want to substitute.
[instance_num] Optional. Which instance to replace. If not entered every instance is substituted.