Thread: Count the number of occurances in a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default Count the number of occurances in a cell
Try this...

=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))

--
Rick (MVP - Excel)


"bobbroda" wrote in message
...
I'm trying to count the number of occurances of a comma in an individual
cell
in Excel. Does anyone have any ideas? thanks.

Reply With QuoteReply With Quote