SUBSTITUTE()

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

 

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
17208439522917628700
true
Search Help Center
true
true
true
false
false