This function substitutes a new string for specified characters in an existing string.
SUBSTITUTE(text,old_piece,new_piece,instance)
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 |
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.
Accepts string data for the text, old_piece, and new_piece arguments, and numeric data for the instance argument. Returns string data.
SUBSTITUTE(""Down Trend"",""Down"",""Up"") gives the result Up Trend
SUBSTITUTE(""Feb 1, 1991"",""1"",""2"", 3) gives the result Feb 1, 1992