SUBSTITUTE
Substitutes all instances of one value with another value
SUBSTITUTE( text, value to find, value to substitute )
Returns a string with all instances of one value replaced by another
Arguments
Arguments
Description
text
String(s) to search for value to find
value to find
Character or string to find in text
value to substitute
Character or string to substitute
Output
Outputs text with all instances of value to find replaced with value to substitute
Example
Last updated