Substitutes new text for old text in a string.
= SUBSTITUTE(text, old_text, new_text[, occurrence])
text - The text in which partial words are to be replaced.
old_text - The partial string to be (repeatedly) replaced. This supports regular expressions.
new_text - The text which is to replace the text string. This supports regular expressions.
occurrence - Which occurrence of the old text is to be replaced.
The "." character in a regular expression is treated as a wildcard and will match any character. For example:
=SUBSTITUTE("secret", ".", "x") results in “xxxxxx”
To replace an actual "." character without matching other characters, escape it by inserting a "\" before the character. For example:
=SUBSTITUTE("10.59", "\.", ":") results in “10:59”
For more advanced regular expressions, we recommend that you search for Regular expression examples using your chosen search engine.