SUBSTITUTE

This function substitutes a new string for specified characters in an existing string.

Syntax

SUBSTITUTE(text,old_piece,new_piece,instance)

Arguments

This function has these arguments:

Argument	Description
text	String or reference to a cell containing the string in which you want to replace characters
old_piece	String to be replaced
new_piece	New string to use instead of existing string
instance	[Optional] Which occurrence of the existing string to replace; otherwise every occurrence is replaced

Remarks

Use this function to replace specific text with other text. Use the REPLACE function to replace a specific number of characters in a specific location with other characters.

Data Types

Accepts string data for the text, old_piece, and new_piece arguments, and numeric data for the instance argument. Returns string data.

Examples

SUBSTITUTE(""Down Trend"",""Down"",""Up"") gives the result Up Trend

SUBSTITUTE(""Feb 1, 1991"",""1"",""2"", 3) gives the result Feb 1, 1992