Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
litLIB: ReplaceAll with multiple strings (Read 1592 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
litLIB: ReplaceAll with multiple strings
04.12.09 at 13:19:29
 
litLIB: ReplaceAll with multiple strings
 
The ReplaceAll function in the litLIB software was changed to be able to replace multiple strings in one go. Multiple strings can now be replaced with other values.
 
Example:
=ReplaceAll(A1,"hi", "Hello","bye","Best regards")
This will replace all hi's and bye's by Hello and Best regards in the value in A1.
 
See also:
The ReplaceAll function
http://www.oraxcel.com/projects/litlib/help/replaceall.html
 
Download litLIB from:
http://www.oraxcel.com/downloads/index.htm?product=litlib
 
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1