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 you want to replace
- 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.
Examples
Still need help?
Use the Smartsheet Formula Template to view examples and practice working with functions in real-time.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.