6 Pairs of numbers in a cell to be automatically individually copied to other cells

[Col Crunch]

I have a cell that contain 6 pairs of numbers which are separated by a spaces. (numbers are formatted as General)

Is there a way each pair of numbers can be automatically placed into their own cell?

Eg: Cell A1 has 01 11 19 24 34 45.

Then:
cell B1 gets 01,
cell C1 gets 11,
cell D1 gets 19,
cell E1 gets 24,
cell F1 gets 34 and
cell G1 gets 45.

Is there a formula that can be used? I would prefer a formula for the solution than using VB.

Any Ideas?

Using Excel 2007

[martindwilson]

a2 filled down
=MID($A$1,FIND("^",SUBSTITUTE($A$1&" "," ","^",ROWS($A$1:A1)))-2,2)

[Col Crunch]

Thanks for the response martin...

I tried your solution, it doesnt seem to work

my data in rows.

The data that is in cell A1 needs to be automatically spread into cells A1 through A7.

Or am I copying it wrong?

[martindwilson]

see attached

[Col Crunch]

How would I get it to work horizontally though? I cant do that vertically by nature of how my spreadsheet is set up.

Or do i just copy the formula to the right?

I just realized that I posted the wrong cells in my post, I edited the post to reflect what I am trying to accomplish....

sorry for the confusion and thanks for your help!

[martindwilson]

b1=MID($A$1,FIND("^",SUBSTITUTE($A$1&" "," ","^",COLUMNS($A$1:A1)))-2,2) filled across

[Col Crunch]

AWESOME!

Thanks a TON Martin!