Returns a copy of the original text with all occurrences of the search text substituted by the replacement text.
Sample usage
REPLACE(Campaign, "Summer", "Spring")
Syntax
REPLACE(X, Y, Z)
Parameters
X
- a field or expression of any type.Y
- a field or expression of any type.Z
- a field or 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 |