Parameter List
Syntax
SUBSTITUTE(original_text, search_for, replace_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.