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