ExcelBanter - Count "," in a cell

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

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

- - Count "," in a cell (https://www.excelbanter.com/excel-worksheet-functions/265145-count-cell.html)

Elton Law[_2_]

Count "," in a cell

Dear expert,

Is it possible to count "," in a cell please?

I used this ... but does not work

=COUNTIF(FO93,",")

Say below ... can it be solved?
2,5,3
22,25,5
5,2,3,4

Jacob Skaria

Count "," in a cell

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

--
Jacob (MVP - Excel)

"Elton Law" wrote:

Dear expert,

Is it possible to count "," in a cell please?

I used this ... but does not work

=COUNTIF(FO93,",")

Say below ... can it be solved?
2,5,3
22,25,5
5,2,3,4

Ms-Exl-Learner

Count "," in a cell

Try this€¦

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

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------

"Elton Law" wrote:

Dear expert,

Is it possible to count "," in a cell please?

I used this ... but does not work

=COUNTIF(FO93,",")

Say below ... can it be solved?
2,5,3
22,25,5
5,2,3,4

All times are GMT +1. The time now is 10:35 AM.