=SUMPRODUCT(--ISNUMBER(VALUE((MID(A2,ROW($A$1:INDEX($A:$A,LEN(A2 ),1)),1)))))


You can simplify to the one below. It looks more elegant

=SUMPRODUCT(--ISNUMBER(--(MID(A1,ROW($1:$255),1))))



"Brad" wrote:

=SUMPRODUCT(--ISNUMBER(VALUE((MID(A2,ROW($A$1:INDEX($A:$A,LEN(A2 ),1)),1)))))
--
Wag more, bark less


"Sasikiran" wrote:

Dear,

I am looking for a formula which counts only the numerical values within a
cell ignoring the special characters, text and anything else and gives the
result in column B using a formula.

Below is the example.

A1 B1
Desired Result
1,804,672-4405,,,,//1,804,672-4405,,,, =
22
1,,201.368.5041,,,,//1,,201.368.5041,,,, =
22
1,503,601-4108
11

Thanks