Function performs replacement of existing text in a text string. Other words Substitute function finds and replaces text (new_text) occurrences based on given text (old_text). Below is the syntax of substitute formula that we will understand by breaking into pieces.
=SUBSTITUTE(text, old_text, new_text, [instance_num]
- text: refers to the string text that you would like to use as input for substitute function. Its mandatory parameter.
- old_text: its mandatory parameter, refers to text that you would like to search within text (fist parameter).
- new_text: its mandatory parameter, refers to text that you would like to replace for each old_text.
- instance_num: its an optional parameter, refers to a number (a positive integer). It determines replacement only given position within string. If omitted, all found instances would be replaced.