SUBSTITUTE

Substitute all occurrences of one string with another.

Syntax

SUBSTITUTE(original_text, search_for, replace_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".

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