replace

Use the replace function to replace an expression in a Text value with another Text value.

Function format

replace(Text source, Text expression, Text replacement)

  • source: the Text value which contains the Text expression that is replaced.
  • expression: the expression in the Text source that is replaced with the Text replacement.
  • replacement: the Text that replaces the Text expression in the Text source.

replace example

replace("Hello, world!", "world!", ", Earth!")

The formula returns the Text value Hello, Earth!