Thread: How do I count just the numbers in a cell, no spaces or comas?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default How do I count just the numbers in a cell, no spaces or comas?
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.
Reply With QuoteReply With Quote