Replaces existing text with new text in a string.
Sample Usage
SUBSTITUTE("Hello Wlrld!", "l", "o", 3)
Syntax
SUBSTITUTE(
- search_text
- old_text
- new_text
- [replace_num]
- search_text—The string containing the text that you want to replace.
- old_text—The text string to have replaced.
- new_text—The text string to replace old_text.
- replace_num—[optional]The instance in search_text to replace old_text with new_text. If omitted, all instances are replaced.
Usage Notes
- The text that you provide in SUBSTITUTE is case sensitive.