Count data in cells
 

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

One way:

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

HTH,

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


"DD" wrote in message
...
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

It worked...Thanks for your help

"RagDyeR" wrote:

One way:

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

HTH,

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


"DD" wrote in message
...
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

Thanks for the feed-back.

--
Regards,

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

"dd" wrote in message
...
It worked...Thanks for your help

"RagDyeR" wrote:

One way:

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

HTH,

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


"DD" wrote in message
...
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