How to extract numbers from a single column which contains rows of text too

[samvince]

Hi how do you extract numbers from a single column which contains rows of text too.

When i get the data it comes in this format in column A

Ideally I'd like it to be like column D and E


Thanks

[Logit]

.
Create a sheet named CONVERTED LIST

Paste in Regular Module :

Please Login or Register  to view this content.

[alansidman]

This can be achieved using Power Query/Get and Transform which is part of Excel 2016 on the Data Ribbon. Look at the link in my signature if not familiar. The Mcode to accomplish this is

Please Login or Register  to view this content.

The file is attached.