The REPLACE function replaces all occurrences of the search string with the replacement string.
#replace(subject, search, replace)
Arguments:
- subject: The input string.
- search: The text to replace.
- replace: The replacement text.
Returns:
- The string with the replaced values.