Removing Text from a cell

Hi, I have 2 columns of data which contains mainly numbers that are either 9 or 10 digits long. However some have got so words at he end which is what I want to remove.

I thought of using text to colums but there is no space or symbol between the number and text.

An example is

0111111100ddddfffffddd

or

0222222222ddddd ffffff ddddd

Any help greatly appreciated

Steve

Hi,

In your example you show the number part starting with a zero, is that the actual case? If not then you could use this

=LOOKUP(100^100,--MID(A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},A1&1234567890)),ROW(INDIRECT("1:"&LEN(A1)))))