Category: Text function
This function replaces all instances of old_text with new_text within text.
| Argument | Type | Description |
|---|---|---|
| text | Text | Any text value or value that can be implicitly converted to text. |
| old_text | Text | The text to be found within text and replaced by new_text, if found. |
| new_text | Text | The text that replaces old_text if found within text. |
Return value type: Text
This function is case sensitive.
Entering '' (two single quotes; an empty string) as the new_text value has the same effect as using the RemoveText function.
Number values entered for text, old_text, and new_text are implicitly converted to text.
replace('Food & Beverage', '&', 'and') //Returns 'Food and Beverage'
replace('New York', 'york', 'Orleans') //Returns 'New York' ('york' isn't found due to the case of 'y'.)
replace('New Mexico', ' ', '_') //Returns 'New_Mexico' (Replaces spaces with underscores.)
replace(123456789, 456, 654) //Returns '123654789' (Number implicitly converted; return value is text.)
replace(190091, "00", 5) //Returns '19591' (Enter multiple zeroes as text; return value is text.)