Replace()

Working with Formulas > Functions Used in Formulas > Text Functions > Replace()

REPLACE() replaces each occurrence of the search string in the input string with the corresponding replace string.

Note: REPLACE() is a case sensitive function.

Function Format

REPLACE(string, search string, replace string) 

Return Value

REPLACE() returns a character string 

Examples

REPLACE("APPLES AND ORANGES", "ORANGES", "APPLES") = "APPLES AND APPLES" 

REPLACE("APPLES AND ORANGES", "APPLES", "ORANGES") = "ORANGES AND ORANGES" 

REPLACE("APPLES AND ORANGES", "ES", "E") = "APPLE AND ORANGE"