SUBSTITUTE
Use the SUBSTITUTE function to replace specific text in a text value.
Use
SUBSTITUTE( text, old_text, new_text [, instance_num] )
Substitutes new text for old text in a text value.
| Parameter | Required | Description |
|---|---|---|
| text | Yes | the text in which to substitute characters |
| old_text | Yes | the text to replace |
| new_text | Yes | the new text to replace old_text with |
| instance_num | No | specifies which occurrence of old_text to replace with new_text (default all) |
| Returns | Text |
Example
This section isn’t ready just yet—we’re working on it! Please check back soon, and if you need help right away, feel free to ask in our Community Forum.
ON THIS PAGE