How do I count just the numbers in a cell, no spaces or comas?

B

bonair

I have dates (1, 15, 21) in various cells. I want to count JUST the dates,
no spaces or comas.
 
J

Jacob Skaria

Suppose A1 = 1, 15, 21
The below formula will give you the number of dates..

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

If this post helps click Yes
 
D

Dave Peterson

=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+(A1<>"")

Will count the number of entries separated by commas.
 

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

Count Word in long string 2
Space at end of multi page list to accommodate new entries 1
Need help on macro to do ranking 2
Combine and display values in range in 1 cell but skip blank cells 3
How to getting text labels to show up in scatter chart. 0
Adding multiple numbers in one cell 16
How to count the numbers in a Word document? 0
specify non-contiguous cell range as arguments to TTEST() 2

Top