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.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment