SUBSTITUTE

Replaces all occurences of a given string with another.

SUBSTITUTE(base_string, old_string, new_string) -> final_string

SUBSTITUTE(base_string, old_string, new_string, occurence) -> final_string

base_string

string -Base string to start with.

old_string

string -The string to replace.

new_string

string -The new string to replace with.

occurence

number -The instance count of the old string to replace.

final_string: string -This is the resulting string from taking the base and replacing the old string with the new string.

← Previous: Reference Tables