litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

String - ReplaceAll

Syntax:
=ReplaceAll(Text , Search , Replace [, Search, Replace], ... )

Description:
Returns a string where all instances of the Search string are replaced with the Replace string in the Text string. Optionally multiple search and replace pairs can be given.

Text : string to search
Search : string to search
Replace : string to replace the instances of the Search string.

Examples:
Replace all comma's with a + symbol:

=ReplaceAll("a,b,c,d,e" , "," , "+")
Result:
"a+b+c+d+e"

Search and replace can be of different size:

=ReplaceAll("As quick as 1,2,3",1,"one",2,"two",3,"three")
Result: "As quick as one,two,three"