REPLACE

Within a string, replaces all instances of a specified substring with a different substring.

Return Value

String

Syntax

REPLACE( string1, string2, string3 )

where:

string1 is the main string where the substring to be replaced (string2) is located.
string2 is the substring to be replaced.
string3 is the replacement string for string2.

Any of these strings can be referenced using an expression.