trim text from numbers

I have a long column with numbers followed by text and sometimes numbers.
examples:

836john
1245football
9213lmv3

I need help in eliminating or trimming all data/numbers after the first number

I want

836john to become 836
1245 football to become 1245
9213lmv3 to become 9213

Any help would be greatly appreciated.

Here, try this (if text is in C5):

=LOOKUP(99^99, --LEFT(C5, ROW($A$1:$A$20)))

This should do the trick..

Please Login or Register  to view this content.

Confirm with CTRL+SHIFT+ENTER