SUBSTITUTE Formula

SUBSTITUTE formula is used to replace character/text with another character/text.

Syntax for SUBSTITUTE formula

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

Parameters Details:

  • text : The original string to use to perform the substitution.
  • old_text : The existing characters to replace.
  • new_text :  The new characters to replace old_text with.
  • instance_num : Optional. It is the nth appearance of old_text that you wish to replace. If this parameter is omitted, then every occurrence of old_text will be replaced with new_text.

Returns

The SUBSTITUTE function returns a string/text value.

SUBSTITUTE Formula Example
SUBSTITUTE Formula Example