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.
