Thread: dot count
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
  
Posts: 3,268
Default dot count
=LEN(A1)-LEN(SUBSTITUTE(A1,".",""))

if you by dot mean a period


--
Regards,

Peo Sjoblom



"nae" wrote in message
...
can I do a dot count in a cell?


Reply With QuoteReply With Quote