Thanx Duke,

But your recommendation in my opinion won't workout for multiple "w" in a
single cell!

"Duke Carey" wrote:

You can also use

=SUMPRODUCT(--(LEN(A1:A3)LEN(SUBSTITUTE(UPPER(A1:A3),"W",""))))

"FARAZ QURESHI" wrote:

Hey Guys!

CHIP PEARSON has justhelped me in an xclent development in this regard i.e.:

For single character
=SUM(LEN(A1:A3)-LEN(SUBSTITUTE(UPPER(A1:A3),UPPER("w"),"")))

& for string:
=SUM(LEN(A1:A3)-LEN(SUBSTITUTE(UPPER(A1:A3),UPPER("wh"),"")))/LEN("wh")

" wrote:

Dear Rick,

I am just being nosy and this thread is of interest to me. I was wondering
if the data extended to say 100 rows, is it possible to count the specific
characters.

Thanks.