count number of times a particular letter appears in a cell
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!
|