Counting specific letters in a cell

[Sandy]

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.

 

[Pete_UK]

Try this:

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

Hope this helps.

Pete

 

[RagDyeR]

Try this:

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


--

HTH,

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

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.

 

[RagDyeR]

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 !
-----------------------------------------------------------------------------------------------

Try this:

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


--

HTH,

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

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.