Returns a copy of the original text with all occurrences of an existing piece of text substituted by the replacement text.
REPLACE(Campaign, "Summer", "Spring")
X- literal text, a field, or an expression containing at least one field.
Y- an existing piece of text.
Z- a replacement text.
||Summer Sale||Spring Sale|
||Summer Sale||Summer Discount|
Was this helpful?
How can we improve it?