On Nov 24, 2:12*pm, Mike H wrote:
Hi,

Try this case sensitive idea

=LEN(A1)-LEN(SUBSTITUTE(A1,"E",""))

Mike



"fallowfz" wrote:
Is there a function which will return the number of times, for
example, the letter "E" appears in a cell containing a mix of text,
numbers, and other characters, e.g. (), :, etc?

Thanks!- Hide quoted text -

- Show quoted text -

WOW...thanks for the quick responses. All of them work great!