replace

Syntax:

Value String  replace(String str, String old, String new)

Description:

Replaces all occurences of old with new in str.

Examples:

($a1:$a5) = replace($self, $b, $c)
Before:
AB C
1Hello WorldHelloGoodbye
2My Name is AlexNn
3ABCabcccABC
44.567123
5XSheetXSheetXSS
616
After:
AB C
1Goodbye WorldHelloGoodbye
2My name is AlexNn
3ABCabcABCccABC
44.567123
5XSSXSheetXSS
616
($d1:$d10) = tolower($b, "0", "")