Excel SUBSTITUTE Function

Excel SUBSTITUTE Function (Example + Video)

Excel SUBSTITUTE Function

When to use Excel SUBSTITUTE Function

SUBSTITUTE function can be used when you want to substitute text with new specified text in a string.

What it Returns

It returns a text string where an old text has been substituted by the new one.

Syntax

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

Input Arguments

  • text – the text you want to change.
  • old_text – the text string that you want to substitute.
  • new_text – the new text string with which you want to substitute old_text.
  • [instance_num] – (optional) the number of times you want to substitute (in case of multiple occurrences). If this argument is not specified, all the instances of old_text are substituted.

Additional Notes

  • If you specify an instance number, then only that instance of the old text is replaced. Otherwise, every occurrence of old text in the text string is changed to new text.
  • Best to use when there is a need to change some specific text with some other text.

Excel SUBSTITUTE Function – Live Example

Excel SUBSTITUTE Function – Video Tutorial

Related Excel Functions:

You may also like the following Excel tutorials:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

Leave a Comment