Need Formula/Help for separating numbers from random text cells

Data.jpg


Hi there

As seen in the attached file, I need to seperate the numbers from text in one go, because this is just an example and i need to seperate numbers from a lot of cells.

I have tried text to coulnms and =right, =left and = substitue formulas... But these does not works because of unique nature of the data, as number in each cell is placed randomly and there are no spaces or common factor between number and text.

Please i need your assistance.