Prev: each cell have same number of charaters
Next: How can I restore a column that was deleted by mistake
From: Teethless mama on 6 May 2010 10:19
> =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
First  |  Prev  | 
Pages: 1 2
Prev: each cell have same number of charaters
Next: How can I restore a column that was deleted by mistake