ExcelBanter - Count the number of occurances in a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Count the number of occurances in a cell (https://www.excelbanter.com/excel-worksheet-functions/232528-count-number-occurances-cell.html)

bobbroda

Count the number of occurances in a cell

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

Rick Rothstein

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.

Jacob Skaria

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.

All times are GMT +1. The time now is 09:54 AM.