|
SUBSTITUTE |
  
|
|
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
See Also