What is the use of SUBSTITUTE function?
SUBSTITUTE Function in Excel replaces old text with new text, in a text string or cell reference. It will replace all instances of the old text, unless a specific instance number is selected.
What is the syntax of SUBSTITUTE function?
SUBSTITUTE(text, old_text, new_text
text : The text for which you want to substitute characters.
old_text: The text you want to replace or remove.
new_text: The text you want to replace old_text with.
instance_num: This is optional parameter. The specific occurrence of old text that you want to replace.
Note:1.The “SUBSTITUTE” function is case sensitive.
2. If you specify “instance_num”, Only that instance of “old_text” will be replaed.
3. If “instance_num” is left blank, It will substitute(replace) every occurrence of”old_text” is changed to “new_text”.
SUBSTITUTE Function in Excel – Examples
Example 1: Replacing underscore(_) with space
Example 2: It will replace the text in first Instance
Example 3: It will replace the text in second Instance
Example 4: Its replaces every occurrence of “w” is changed to “p”
Example 5: Its replaces the Space character in the text
Please refer the below article for more Text Excel functions.
Text Excel Formulas
Please refer the below article for more Excel Functions.
Excel Formulas | Home
how to change cell value ( many cells ) to comments at once??