REPLACE function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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.
Issues:
- Excel and the ODFF standard allow length to be zero.
See Also
