REPLACE
Returns a copy of the original text, replacing all occurrences of the search text with the replacement text.
Sample usage
REPLACE(Campaign, "Summer", "Spring")
Syntax
REPLACE( X, Y, Z )
Parameters
X- a field or an expression of any type.Y- a field or an expression of any type.Z- a field or an expression of any type.
Examples
| Example formula | Input | Output |
|---|---|---|
REPLACE(Campaign,"Summer","Spring") |
Summer Sale | Spring Sale |
REPLACE(Campaign,"Sale","Discount") |
Summer Sale | Summer Discount |