# SUBSTITUTE

## Content

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* | [Required] String or reference to a cell containing the string in which you want to replace characters |
| *old\_piece* | [Required] String to be replaced |
| *new\_piece* | [Required] 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.

## Examples

`SUBSTITUTE("Down Trend","Down","Up")` gives the result Up Trend
`SUBSTITUTE("Feb 1, 1991","1","2", 3)` gives the result Feb 1, 1992