Count number of times a 6 digit number show up in a cell

Hello and thank you in advance.

I've ran across an interesting situation that I cant figure out.

I get a report with detailed information in each cell with anywhere from 1 to 50 six digit client numbers included in the text (Somewhere and at times grouped with letters because the user failed to hit space)

what I'm trying to do is create a formula that will count the number of these 6 digit groups in each cell so I can see how many clients each comment is related to.

I've attached a example sheet
- Column A has mocked up text and number combo's - the 6 digit long groupings I'm trying to count are bold and red.
- Column B is the end number the formula should return.

I'm stumped so anything you can do will help.

Hi,

=COUNT(1/(MMULT(ABS({1,0,0,0,0,0,0,1}-ISNUMBER(0+MID(MID("ζ"&A2&"ζ",ROW(INDIRECT("1:"&LEN(A2)-5)),8),{1,2,3,4,5,6,7,8},1))),{1;1;1;1;1;1;1;1})=8))

and copied down.

Regards

Please try at B2

=SUM(--(FREQUENCY(IF(ISNUMBER(-MID(A2,ROW($A$1:$A$99),1)),ROW($A$1:$A$99)),IF(ISERROR(-MID(A2,ROW($A$1:$A$99),1)),ROW($A$1:$A$99)))=6))

and press Ctrl+Shift+Enter

@XOR LX and fireguy7
Thanks for the reps

A bit shorten one

=SUM(--(FREQUENCY(ROW($A$1:$A$99),IF(ISERROR(-MID(A2,ROW($A$1:$A$99),1)),ROW($A$1:$A$99)))=7))