Extract numbers before first instance of text

This array formula seems to work

=1*MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$9),1)),0),COUNT(1*MID(A1,ROW($1:$9),1)))

This is limited to 9 numbers
Increase the $9s if you want more numbers

Also, non-array:

=LEFT(A1,MATCH(1,INDEX(0+ISERR(0+MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),,),0)-1)

Regards

=LOOKUP(9^9,LEFT(A1,ROW(1:256))*1,LEFT(A1,ROW(1:256))*1)
Try this

Originally Posted by nflsales

=LOOKUP(9^9,LEFT(A1,ROW(1:256))*1,LEFT(A1,ROW(1:256))*1)
Try this

You always have to be careful with this type of solution. In general, it will work in 99.9% of cases, but what, for example, if the OP had this string in A1:

23June14

(formatted as text, of course), and wanted to extract 23?

What does your formula give then?

Regards