How do I count the number of specific letters in a given cell? For example
if a cell has the words "Have a nice day!" I would only want to count only
the letter "a." Is there some sort of IF-LEN-combo function? Help.

Try this:

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

Hope this helps.

Pete

On Jul 3, 4:35*pm, Sandy <Sa...@discussions.microsoft.com> wrote:
> How do I count the number of specific letters in a given cell? *For example
> if a cell has the words "Have a nice day!" I would only want to count only
> the letter "a." *Is there some sort of IF-LEN-combo function? *Help.

Try this:

=LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),"A",""))


--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"Sandy" <(E-Mail Removed)> wrote in message
news:59896727-9F10-4154-BF82-(E-Mail Removed)...
How do I count the number of specific letters in a given cell? For example
if a cell has the words "Have a nice day!" I would only want to count only
the letter "a." Is there some sort of IF-LEN-combo function? Help.

This works for:
"Have a nice day!"

As well as:
"A nice day was had by all!"
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"RagDyeR" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
Try this:

=LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),"A",""))


--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"Sandy" <(E-Mail Removed)> wrote in message
news:59896727-9F10-4154-BF82-(E-Mail Removed)...
How do I count the number of specific letters in a given cell? For example
if a cell has the words "Have a nice day!" I would only want to count only
the letter "a." Is there some sort of IF-LEN-combo function? Help.