Count specific numbers in a cell and not characters

[gjjh25]

I am trying to get excel to count the number of numbers only in a cell and exclude other characters.

I have tried count and currently trying LEN, it is close but it is counting everything.

I have enclosed a sample is someone could help please?

[iustin]

Use this formula:
=LET(a,FILTERXML("<t><s>"&SUBSTITUTE(F5,"-","</s><s>")&"</s></t>","//s"),IF(OR(ISNUMBER(a)=TRUE),COUNT(a)))

The delimitator in the formula for different numbers is "-" ,if you have a different one change that in the formula

I also attached your file with the formulas

[gjjh25]

Thank you that has worked perfectly

[Bo_Ry]

try

=LEN(F5)-LEN(SUBSTITUTE(F5,"-",))+1

or spill array

=LEN(F5:F19)-LEN(SUBSTITUTE(F5:F19,"-",))+1