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 Swedish characters (Read 2035 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
litLIB: ReplaceAll with Swedish characters
04.12.09 at 10:28:17
 
litLIB: ReplaceAll with Swedish characters
 
Quote:
Is it possible for you to change the ReplaceAll function, so I can do this to solve the swedish characters.
=ReplaceAll(B24;"å";"";"ä";"";"ö";"")

å =
ä =
ö =

etc..

 
I like the syntax of this. I will change the function ReplaceAll to accept multiple Search and Replace pairs.  
 
Unfortunately nesting does not work as we hit the 255 character passing problem wher only 255 characters can be passed directly from one formula to the next:
=ReplaceAll( ReplaceAll( ReplaceAll(B24,"å","") ,"ä",""), "ö","")
 
The following works like a charm:
A2: =ReplaceAll(A1,"å","")
A3: =ReplaceAll(A2, "ä","")
A4: =ReplaceAll(A3, "ö","")
Back to top
 
« Last Edit: 04.12.09 at 13:15:20 by Gerrit-Jan Linker »  

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