Count the number of occurances in a cell

  • Thread starter Thread starter bobbroda
  • Start date Start date
B

bobbroda

I'm trying to count the number of occurances of a comma in an individual cell
in Excel. Does anyone have any ideas? thanks.
 
With the text in A1 try

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

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting the number of times a character occurs in a cell 1
counting no. of times a character occurs in a cell 3
Excel 2003 Counting multiple number entries in a single cell 6
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Counting Individuals not Occurrences in Excel 2007 2
count no. of commas (,) in a string in a cell 3
Countif formula perhaps 7
Count a number in a range with cells containing more than one numb 12

Back
Top