Count data in cells

D

DD

If I enter the following into one cell what formula do I use so it recognize
it?

628.9,v14.0,v15.08

I want it to equal 3
 
R

RagDyeR

One way:

=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+1
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


If I enter the following into one cell what formula do I use so it recognize
it?

628.9,v14.0,v15.08

I want it to equal 3
 
Top