REPLACE

Returns a copy of the original text with all occurrences of an existing piece of text substituted by the replacement text.

Sample usage

REPLACE(Campaign, "Summer", "Spring")

Syntax

REPLACE(X,Y,Z)

Parameters

  • X - literal text, a field, or an expression containing at least one field.
  • Y - an existing piece of text.
  • Z - a replacement text.

Examples

Example formula Input Output
REPLACE(Campaign,"Summer","Spring") Summer Sale Spring Sale
REPLACE(Campaign,"Sale","Discount") Summer Sale Summer Discount

Related resources

Was this helpful?
How can we improve it?

Need more help?

Sign in for additional support options to quickly solve your issue