Haseeb Sir,
I am becoming a FAN of you... You seem to have super knowledge of
Formulas... tooo good...
On Thu, Jul 21, 2011 at 9:58 PM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:
> 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
>
--
----------------------------------------------------------------------------------
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
