Skip to main content

SUBSTITUTE

Replaces specific text in a text string with new text.

Syntax​

SUBSTITUTE(text, old_text, new_text, [instance_num])

Arguments​

  • text: The text or reference to a cell containing text in which you want to substitute characters.
  • old_text: The text you want to replace.
  • new_text: The text you want to replace old_text with.
  • instance_num: [Optional] Specifies which occurrence of old_text you want to replace. If omitted, all occurrences are replaced.

Example​

SUBSTITUTE("AnyDB Database", "DB", "Data") → Returns "AnyData Database"
SUBSTITUTE(A1, "old", "new") → Replaces all instances of "old" with "new" in cell A1