Navigation:  Formula Reference > Spreadsheet Formula Functions >

SUBSTITUTE

Previous pageReturn to chapter overviewNext page

 

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

 

See Also

FIND

REPLACE

TRIM