Excel Functions

Excel SUBSTITUTE Function

Pinterest LinkedIn Tumblr

The SUBSTITUTE function replaces text in a given string by matching. SUBSTITUTE is case-sensitive and does not support wildcards.

Purpose of Excel SUBSTITUTE Function

Replace text based on content.

Return value

The processed text.

Syntax

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

Arguments

ArgumentsDescriptionRemarks
textThe text to changeMandatory
old_textThe text to replace Mandatory
new_textThe text to replace withMandatory
instanceThe instance to replace. If not supplied, all instances are replacedOptional

Usage notes

  • SUBSTITUTE finds and replaces old_text with new_text in a text string.
  • Instance limits SUBSTITUTE replacement to one particular instance of old_text.
  • Use SUBSTITUTE to replace text based on content.
  • Use the REPLACE function to replace text based on its location.
  • SUBSTITUTE is case-sensitive and does not support wildcards.

Availability

Since 2007 for Windows.
Since 2011 for Mac.

Related Posts

Write A Comment