REPLACE


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

Syntax:

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.

Example:

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






 
Created with Zapof