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()