Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge encOffice: Protect your Excel file easy and safe
Home Products litLIB Help String functions

Buy now

Download now

LITlib - Excel Power Functions Pack
 
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - ReplaceAll function
litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

String - ReplaceAll

Syntax:
=ReplaceAll(Text , Search , Replace )

Description:
Returns a string where all instances of the Search string are replaced with the Replace string in the Text string.

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

Example:
Replace all comma's with a + symbol:
=ReplaceAll("a,b,c,d,e" , "," , "+")

litLIB