Thread: Extract number from text field

I would gladly help you for free but your issue is not so simple, so have a little patience

waiting bro.............

it will solve my big problem and save time........

try ,adapted from here http://www.teachexcel.com/excel-help/ev.php?i=124211
=MID($A1&"x000000",MATCH(TRUE,INDEX(ISNUMBER(MID(SUBSTITUTE($A1," ","^")&"x000000",ROW($A$1:INDEX($A:$A,LEN($A1)+1)),6)+0),0),0),6)+0
then with a few helper columns
see attached
hm i done this in xls might be tidier with iferror

This version will return "Too long" where you have 7 digit numbers in rows 2 and 14

=IF(ISNUMBER(LOOKUP(10^7,MID(SUBSTITUTE(SUBSTITUTE(C2,".","x")," ","x"),ROW(INDIRECT("1:"&LEN(SUBSTITUTE(SUBSTITUTE(C2,".","x")," ","x"))-6)),7)+0)),"Too Long",LOOKUP(10^6,MID(SUBSTITUTE(SUBSTITUTE(C2,".","x")," ","x"),ROW(INDIRECT("1:"&LEN(SUBSTITUTE(SUBSTITUTE(C2,".","x")," ","x"))-5)),6)+0))