REPLACE

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