Text with replacements
Returns the resulting text with the specified text replaced with new text.
Sample usage
SUBSTITUTE("abc", "a", "A")
returns Abc
SUBSTITUTE("+1 212-555-1212", "-", ".")
returns +1 212.555.1212
SUBSTITUTE("Hello, {}!", "{}", "Bob")
returns Hello, Bob!
Syntax
SUBSTITUTE(text-to-search, search-for, replace-with)
text-to-search
- Any textual type that specifies the text containing occurrences ofsearch-for
to be replaced withreplace-with
.
-
search-for
- Any textual type that specifies the text to be replaced where found intext-to-search
.
replace-with
- Any textual type that specifies the text to replace each occurrence ofsearch-for
found intext-to-search
.
See also