I have a long column with numbers followed by text and sometimes numbers.
I need help in eliminating or trimming all data/numbers after the first number
836john to become 836
1245 football to become 1245
9213lmv3 to become 9213
Any help would be greatly appreciated.