SUBSTITUTE function

The SUBSTITUTE function is one of the text and data functions. Is used to replace a set of characters with a new one.

Syntax

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

The SUBSTITUTE function has the following arguments:

Argument	Description
text	The string to perform the substitution within.
old_text	The string to replace.
new_text	The string to replace with.
instance_num	The number of occurences to repleace. It is an optional argument, if omitted, the function will replace all the occurences within text.

Notes

How to apply the SUBSTITUTE function.

Examples

The figure below displays the result returned by the SUBSTITUTE function.