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

SUBSTITUTE("Spreadsheets", "Spread", "Bed")
>> "Bedsheets"