you can try this
if "excel" is in A2 cell then LEN(A2)-LEN(SUBSTITUTE(A2,"e",""))
Regards
Muni
On Fri, Dec 9, 2011 at 3:10 PM, hanumant shinde wrote:
> Hi All,
>
> it was an interview que.
>
> how will you find number of occurrence of any character
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
>
> <>
t;><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
> --
>
>
m/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
>