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?