REPLACE

Syntax

REPLACE (Text, Old, New)

Description

The REPLACE function replaces all occurrences of Old with New in text and returns the result.

Example

REPLACE("StringFun", "Fun", "Number") returns StringNumber.