Delete text, split numbers to two cells and store as numbers

Hi there forum

I need to remove all text from cells in a particular column, then split the remaining numbers across two different named columns. I realise this explanation is weak so I've attached a sample which should make it much clearer!

The sample is just that, in reality there will be 100s/1000s of rows.

This will join part of an existing macro with actions before and after it.

Thanks as ever for the help, you've been great recently!

Steve

Great, thanks Greg!