formula to count commas
mucho gracias
"Peo Sjoblom" wrote:
To count commas
=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))
for range of cells
=SUMPRODUCT(LEN(A1:A10)-LEN(SUBSTITUTE(A1:A10,",","")))
--
Regards,
Peo Sjoblom
"Janis" wrote in message
...
I have different multiples of 4 character strings delimited by commas in a
column of cells. I just need to count the commas so I can have the number
of
multiples of 4 strings. For example, I could have ABCD, in cell one. In
cell 2 I could have ABCD,EFGH, in the next cell. In cell 3 I could have
ABCD,EFGH,IJKL,
I don't know what the string functions would be. But I need to count
those
groupings of 4 characters.
Something like this?
count( left(4,","))
thanks,
|