If you have a column of items like and want to count the "a" character:

asdfd
aa
dfa
ffdq
faasf
ccv
aarwwe
a32
tg3q

then use:

=SUM(LEN(A1:A100)-LEN(SUBSTITUTE(A1:A100,"a",""))) to display 9

This is an array formula that must be entered with CNTRL-SHFT-ENTER rathr
than just the ENTER key
--
Gary''s Student - gsnu200832


"Andrea" wrote:

I have a column of cells containing strings of numbers and letters. I'm
trying to count the occurrence of individual numbers and letters. What
function should I use?