SUBSTITUTE
Substitutes a text string with a new text.
Syntax
=SUBSTITUTE(Text, OldText, NewText, [Occurrence])
Arguments
| Name | Type | Description |
|---|---|---|
| Text | String | Text for which to substitute characters. |
| OldText | String | The text to be replaced. |
| NewText | String | The text which will replace specified OldText. |
| Occurrence (optional) | Number | Specifies which occurrence of OldText to be replaced by NewText. If not specified every occurrence of OldText will be replaced. |
Return
| Type | Description |
|---|---|
| Number | A string value with replaced text. |
Examples
| Formula | Result | Comment |
|---|---|---|
| "Replace me later" |