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!