I can get them split into separate columns, but not rows..you'll probably need VBA for that....

To get separate columns, select the column and go to Data|Text to Columns

select Delimited and click Next

Select Other and in the box next to it hold the Alt key down and enter 010 using the Number keypad on the right of your keyboard.

Click Finish.