REPLACE

The REPLACE function searches for a string within a target string. If the search string is found, the replacement string is substituted for the search string.

Syntax

REPLACE('string', 'searchString', 'replacementString',)

Return

Text string

Example

REPLACE('quick', 'ic', 'ar') = 'quark'