SUBSTITUTE

Substitute all occurrences of one string with another.

Parameter List

Syntax
SUBSTITUTE(original_textsearch_forreplace_with)
original_text

The text to change. For example: "Awesome tool" or A3.

search_for

The string to replace. For example: "Awesome".

replace_with

The string to replace search_for string with. For example: "Brilliant".

Examples

SUBSTITUTE("Hello Berlin", "Berlin", "Porto") returns "Hello Porto"