Replace

Finds the specified substring(s) and replaces it with the new text

Replace("The River", "i", "o") → "The Rover"
Replace("Netherland", "Ne", "Mo") → "Motherland"

Inputs

Replace(string, search, replacewith, [isCaseSensitive], [allMatches])

• string - A text value to search in

• search - Text to search for

• replaceWith - Text to replace with

• [isCaseSensitive] - [optional: true by default**]** - Set false if search should be case insensitive

• [allMatches] - [optional: true by default**]** - Set false if only the first match should be replaced