On 20 Mai, 18:30, "T. Valko" wrote:
Try this...

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

Note that SUBSTITUTE is case sensitive.

--
Biff
Microsoft Excel MVP

"Elton Law" wrote in message

...

Dear exper
A cell contains a lot of information.
Is it possible to count certan word in a cell please?

Say A1 contains a series of text ....

1. Daily Swing even though Sto is hit high or low
2. Look at Chart pattern
3. Stop at dangerous level

How can I count number of "O" in the cell A1 please?

Thanks
Elton

Hi Biff,

I like that UPPER("O") part :-)

Have fun,
Bernd