SUBSTITUTE

Substitute all occurrences of one string with another.

Parameter List

Syntax
SUBSTITUTE(original_textsearch_forreplace_with
[occurrence_number]
)
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".

[optional] occurrence_number

Replaces search_for in text_to_search with replace_with. By default, every match is replaced. If you set occurrence_number, only that specific match is replaced.

Examples

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