SUBSTITUTE(template, old-text, new-text)


SUBSTITUTE() generates a new value from template (of any textual type) by replacing all occurrences of old-text (of any textual type) with new-text (of any textual type).

Return Value

A Text value: the text of template with all occurrences of old-text replaced with new-text.

Did this answer your question?