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 |