Hello Prabhu,
Use SUBSTITUTE. or excel's Find/Replace command
SUBSTITUTE is a case sensitive function, so you need convert the cell to
UPPER or LOWER, so use,
=SUBSTITUTE(UPPER(A1),"ABC","")
Or,
=SUBSTITUTE(LOWER(A1),"abc","")
All the letters in 1st output will be in CAPITAL LETTERS
All the letters in 2nd output will be in small letters.
If you need the results as the same as original, Try this,
=INDEX(SUBSTITUTE(A1,{"ABC","abc"},""),MATCH(MIN(LEN(SUBSTITUTE(A1,{"ABC","abc"},""))),LEN(SUBSTITUTE(A1,{"ABC","abc"},"")),0))
Or use Find/Replace command. select the range, Press Control+F
Find What: abc
leave the Replace with blank, then click Replace All
HTH
Haseeb
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
