Thread: Count the number of occurances in a cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Count the number of occurances in a cell
With the text in A1 try

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

If this post helps click Yes
---------------
Jacob Skaria


"bobbroda" wrote:

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