FORMULA TO REMOVE TEXT FROM A CELL
I thought you said that for 13.5 Kilogram you wanted the result to be 13.5?
Doesn't that formula return 135?
--
David Biddulph
"Faraz A. Qureshi" wrote in
message ...
Mike H's following Array formula turned out to be great:
=MID(SUMPRODUCT(--MID("01"&A1,SMALL((ROW($A$1:$A$300)-1)*ISNUMBER(-MID("01"&A1,ROW($A$1:$A$300),1)),ROW($A$1:$A$300)) +1,1),10^(300-ROW($A$1:$A$300))),2,300)
--
Best Regards,
Faraz
"David Biddulph" wrote:
That'll need VBA, not a formula.
--
David Biddulph
"Faraz A. Qureshi" wrote in
message ...
I am sorry what I sought was to have all the text be removed. Like:
1234Text
12Text34
Text1234
be converted to:
1234
1234
1234
--
Best Regards,
Faraz
"David Biddulph" wrote:
=IF(ISNUMBER(A1),A1,--LEFT(A1,FIND(" ",A1)-1))
--
David Biddulph
"Faraz A. Qureshi" wrote in
message ...
I have some entries like:
10 Kg
15 Kilo
12
13.5 Kilogram
How, to have all the text be removed from the same having the
numericals
remained presented as:
10
15
12
13.5
--
Best Regards,
Faraz
|