Count data in cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
==============================================


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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
CountIf previous cell formula 0
Count data in cells 3
Countif problem 2
If - Then formula 4
Set non-continuous PrintArea via Function / Name 0
Formula For Counting Records 5
Excel Formula 2

Back
Top