Count

[Garry]

Hi I want to count the number of instances a comma "," appears in one cell

For instance Xxxxx xxx, xxxxxx xxx xxx xx, xxxxxx xxx xxx etc =2
or Xxxxxxxxxxxxx, xxx xx x xxxxxx xxx xxx, xxxx xxx xxx, =3

How do I write this please

Garry

 

[Claus Busch]

Hi Garry,

Am Thu, 19 Jan 2012 14:17:47 -0000 schrieb Garry:

For instance Xxxxx xxx, xxxxxx xxx xxx xx, xxxxxx xxx xxx etc =2
or Xxxxxxxxxxxxx, xxx xx x xxxxxx xxx xxx, xxxx xxx xxx, =3

yourcell is A1, then try:
=LEN(A1)-LEN(SUBSTITUTE(A1,",",))


Regards
Claus Busch

 

[Garry]

Hi Claus

=LEN(M2)-LEN(SUBSTITUTE(M2,",",))

Gives me a result of FALSE

Can you improve please, Garry

 

[Garry]

Sorry pasted it incorrectly, Many thanks, Garry

Hi Claus

=LEN(M2)-LEN(SUBSTITUTE(M2,",",))

Gives me a result of FALSE

Can you improve please, Garry