SUBSTITUTE function | excel replace text
ThisarticledescribestheformulasyntaxandusageoftheSUBSTITUTEfunctioninMicrosoftExcel. Description Substitutesnew_textforold_textinatextstring.UseSUBSTITUTEwhenyouwanttoreplacespecifictextinatextstring;useREPLACEwhenyouwanttoreplaceanytextthatoccursinaspecificlocationinatextstring. Syntax SUBSTITUTE(text,old_text,new_text,[instance_num]) TheSUBSTITUTEfunctionsynta...
This article describes the formula syntax and usage of the SUBSTITUTE function in Microsoft Excel.
DescriptionSubstitutes new_text for old_text in a text string. 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.
SyntaxSUBSTITUTE(text, old_text, new_text, [instance_num])
The SUBSTITUTE function synta...