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

's Computer Specifications

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

's Computer Specifications

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
---------------
Jacob Skaria

"bonair" wrote:

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

's Computer Specifications

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

Will count the number of entries separated by commas.

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

--

Dave Peterson

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to remove empty spaces in a cell with numbers?	=?Utf-8?B?VG9iaWFz?=	Microsoft Excel Worksheet Functions	2	24th Oct 2007 02:08 PM
Tough One. Data on one cell seperated by comas.	=?Utf-8?B?RGF2aWQgQg==?=	Microsoft Excel Misc	1	1st Mar 2007 06:55 AM
Adding spaces between numbers in a cell that contains a full address	chunt@vvsii.com	Microsoft Excel Discussion	4	6th Nov 2006 06:39 PM
automatic comas for numbers greater than 999	=?Utf-8?B?am9uajM0?=	Microsoft Excel New Users	1	10th Aug 2006 09:06 PM
COUNT THE NUMBER OF LETTERS INCLUDING SPACES IN A CELL?	=?Utf-8?B?enVyYWZ6Ng==?=	Microsoft Excel Worksheet Functions	7	6th Mar 2006 07:53 AM