SUBSTITUTE Function in Excel

In this post, let’s find out how the SUBSTITUTE Function works in excel, describe the formula syntax, and how you can use the SUBSTITUTE Function in your excel spreadsheet. 

What is SUBSTITUTE Function in Excel? 

The SUBSTITUTE Function in Excel is used to replace or substitute a given text with another text in a given cell. 

Syntax

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

Parameter 

• Text– The text from which we want to substitute some text. 
• Old_text– The text which is going to replace. 
• New_text– the text which replaces the old text. 
• Instance_num– (Optional) The instance used where the instance of the old text is replace 

Example

=SUBSTITUTE(A2,”WELCOME”,”THANKS”) 

=SUBSTITUTE(A6,”@#”,” “) 

How to use SUBSTITUTE Function in Excel? 

The following steps will explain the work of the SUBSTITUTE function in an excel spreadsheet: 

• Create an Excel spreadsheet with the specified data in it. 
• Here, in this example, we are going to perform the SUBSTITUTE Function let’s begin with the SUBSTITUTE command following the “=” operator within the parenthesis declare the new text to replace the old text in the order of syntax. 

Note: 

The SUBSTITUTE Function is the case-sensitive function.