SUBSTITUTE function in Excel

Here’s a tutorial that explains how you can use the SUBSTITUTE function in your Microsoft Excel spreadsheet.

What is the use the Substitute Function in Excel?

Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string.

The following steps will explain the work of Substitute Function in Excel:

  • First, prepare an excel sheet with the required details in it.
How to use SUBSTITUTE function in Microsoft Excel?
  • To get started use the following formula: SUBSTITUTE(text, old_text, new_text, [instance_num]).
  • The below picture is an example of a Substitute Function in an excel spreadsheet.
SUBSTITUTE function in Excel

We hope that this article will be resourceful and understandable.