Txt to columns
 

Well, you could record Text to Columns in a macro to shorten the
keystrokes. Or someone could probably write a long, choppy formula
using MID and FIND and such functions to do this.

I like using morefunc, which is a set of UDFs you can find on the net.
So, assuming you import the numbers to column A, this formula in B1:
=VALUE(WMID($A1,COLUMN()-1,1,"xx"))

Assuming you want the numbers to be values, I wrapped this with VALUE.
And the "xx" would have to be whatever is between the numbers from
your import. Copy across and down to as many cells as necessary.