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.
Example:
REPLACE("Vive la reine", 9, 5, "revolution")
returns the text string "Vive la revolution"
.