Translate()

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

TRANSLATE() replaces each character in a string that matches a character in the search list with a corresponding character in the replace list. If a character in the search list has no corresponding character in the replace list, TRANSLATE() removes it from the string.

NOTE: TRANSLATE() is a case sensitive function.

Function Format

TRANSLATE(string, search list, replace list) 

Return Value

TRANSLATE() returns a character string 

Examples

TRANSLATE("APPLES", "PLES", "ples") = "Apples" 

TRANSLATE("APPLES AND ORANGES", "S", "") = "APPLE AND ORANGE" 

TRANSLATE("APPLES AND ORANGES", "DLGORAPESN ", "RFTUI") = "FRUIT"