Replaces part of a text string with a different text string.


REPLACE(originaltext, startposition, length, newtext)
in originaltext, removes length characters beginning at character startposition, replaces them with newtext, and returns the result.
startposition and length must be 1 or more.


REPLACE("mouse", 2, 3, "ic")
returns mice. Beginning at character position 2, 3 characters (ous) are removed and replaced by ic.

Created with Zapof