Search for "C" within text string

[takformaten]

This thing is making me wanting to do stuff I could never quote on a public forum!!!

OK what I want to do is the following.

In A1 I got 1C/3C/9C/10C
In A2 I got 1C
In A3 I got 1C/10C/11C

I want Excel to count the number of Cs within the cell.

Result would be

A1: 4
A2: 1
A3: 3

Any ideas, please??? Can't be that hard...

Reg.
Takformaten

 

[Juan Pablo González]

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

and drag down.

 

[takformaten]

Gracias! Thanks! Danke!

Funny enough my colleagues don't believe me this ommunity actually works... Well my advantage, isn't it?!?!

 

[Brian from Maui]

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

and drag down.

JPG,

How can you make it non case sensitive?

 

[Aladin Akyurek]

...

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

...

How can you make it non case sensitive?

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

 

[Brian from Maui]

Thanks!