Function REPLACE()

 

Description
Replaces all occurrences of a value in a string or array with a specified replacement.

Syntax

REPLACE(string, searchValue, replaceValue)

REPLACE(array, searchValue, replaceValue)

Parameters

• string/array – The source string or array (text, number, or date)
• searchValue – The value to find (must match type if array)
• replaceValue – The value to replace with

Return Value
TEXT

 

Examples

Formula

REPLACE("SharpCloud", "S", "My S")

Result
"My SharpCloud"

Formula

REPLACE("SharpCloud", "harp", "HARP")

Result
"SHARPCloud"

Formula

REPLACE("SharpCloud", "C", "")

Result
"Sharploud"

Formula

REPLACE(REPLACE("SharpCloud", "Cloud", "Water"), "Sharp", "Smart")

Result
"SmartWater"

Formula

REPLACE(['A','B','C'], 'B', 'D')

Result
['A','D','C']

Formula

REPLACE([1,1,2,3,4,5,6,7], 1, 0)

Result
[0,0,2,3,4,5,6,7]

Notes

• Replaces all matching instances
• Array replacements must use matching data types
• Can be nested for multiple replacements