On Thu, 20 May 2010 11:24:51 -0700 (PDT), Bernd P
wrote:

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

To be really sure, make it TRIM(LEFT(UPPER("O"))) :-)

Lars-Åke