Help extracting single numbers

[12Torquay12]

Hi I am trying to isolate single numbers (the numbers are size 6, 7, 8 and 9) and nothing else. The numbers I want have a space after if they have anything else I needs to be ignored
I am using power query to try and achieve this
Attachment 736502
As you can see from the picture I have managed to get rid of the 1st 4 numbers (column B) but I need to isolate the single numbers (with a space afterwards)
I want from 6 STND ... 6 as an example but from lets say 2XL AG ... I want it blank or null

Hope this makes sense

Thanks
Kim

[JohnTopley]

Please update your profile with the Excel version (2016, 2019 365 etc)you have as answers can/do depend on knowing this.

[12Torquay12]

Please accept my apologies
its 365

Kind regards
Kim

[Fluff13]

How about

=IFERROR(FILTERXML("<k><m>"&SUBSTITUTE(A2," ","</m><m>")&"</m></k>","//m[string-length()=1and number()]"),"")

[12Torquay12]

Worked great thank you
I wish I understood better on how this works so I can write better formulas

Thank you again
Kim

[AliGW]

Please update your forum profile to MS365 - it currently says Windows 10, which is NOT your Office version. Thanks.