Replaces a specified part of a text string with another.
Syntax:
REPLACE(text, start:Number, length:Number, new:Text)
Replaces the part of the text string starting at position start and continuing for length characters with the new text string.
Note that length may be zero, in which case the new text is inserted without replacing any previous content.
Example:
REPLACE("Vive la reine", 9, 5, "revolution")
returns the text string "Vive la revolution"
.