Statistical - SUBSTITUTE Function

Description

Substitutes new_text for old_text in a text string.

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

Argument	Description	Required/ Optional
Text	The text or the reference to a cell containing text for which you want to substitute characters.	Required
Old_text	The text you want to replace.	Required
New_text	The text you want to replace old_text with.	Required
Instance_num	Specifies which occurrence of old_text you want to replace with new_text. If you specify instance_num, only that instance of old_text is replaced. Otherwise, every occurrence of old_text in text is changed to new_text.	Optional

Use SUBSTITUTE when you want to replace specific text in a text string.
Use REPLACE when you want to replace any text that occurs in a specific location in a text string. .

Excel 2007, Excel 2010, Excel 2013, Excel 2016

advanced_excel_statistical_functions.htm