Prev: VLOOKUP returns incorrect data
Next: Function help please.
From: Elton Law on 3 Jun 2010 07:03
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



From: Jacob Skaria on 3 Jun 2010 07:18
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
>
>
>
From: Ms-Exl-Learner on 3 Jun 2010 07:18
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
>
>
>
 | 
Pages: 1
Prev: VLOOKUP returns incorrect data
Next: Function help please.