oracle_dba
Saturday, January 2, 2010
String manipulation using Excel Nested Functions
Convert number +91 (11) 2000-5658 to 20005658
=int(CONCATENATE(MID(B2,SEARCH("+91",B2)+9,4),MID(B2,SEARCH("-",B2)+1,4)))
Happy New Year 2010 to all Blog Readers.
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)
