Excel formula questions

[Summerrr]

Hi guys,

I have a question about the "count" formulas in excel. In the cell below, there are 10 sets of 3-digit-code in there. I'm wondering what the formula would be in order for me to count the sets with in this cell. Can anyone help me with this please?

M22 D01 D07 D09 D92 Db5 Db6 Du3 Du5 Dv3 <tbody> </tbody>

<tbody>
</tbody>

 

[Jonmo1]

Is there ever anything other than 3 digit codes?
You could do
=LEN(A1)/3

 

[PatOBrien198]

If the codes were all entered in a single cell, with Alt+Enter used to drop to a new line within the cell, then the formula would need to be:
=LEN(SUBSTITUTE(A1,CHAR(10),""))/3
The Alt+Enter puts in a line-feed character (Char(10))

 

[Summerrr]

Hi Jonmo1,

Thanks for the answer! I pasted this formula in excel and the number it returned is 13 instead of 10...And no there are only 10 sets of 3 digit codes in that cell.

 

[Summerrr]

Thanks!!