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.