REPLACE

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".