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.
- Excel and the forthcoming ODFF standard allow length to be zero.