TRIM or LEFT Function - Extract number until first non-numerical character

[horizonflame]

Hi All

I have some raw data in one column. The format of the cells is a number followed by either a space or text. I am looking to extract only the first number with a formula.

Thank for the help!

 

[Aladin Akyurek]

Brilliant thanks, there won't be anywhere near 99 characters so all good cheers!

You are welcome.