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?

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl68, width: 64"]M22 D01 D07 D09 D92 Db5 Db6 Du3 Du5 Dv3[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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!!