SUBSTITUTE()

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 of search-for to be replaced with replace-with.

• search-for - Any textual type that specifies the text to be replaced where found in text-to-search.

• replace-with - Any textual type that specifies the text to replace each occurrence of search-for found in text-to-search.

See also

CONCATENATE()

CONTAINS()

FIND()

INITIALS()

LEFT()

MID()

RIGHT()

TRIM()