reformatting a list into separate columns using a macro

Well what it is, is that i have been given a list of 186492 little codes and i need to separate them into different columns.
20070312,2310,1419.25,1419.5,1419.25,1419.5,9,9
20070312,2320,1419.5,1419.5,1419.25,1419.25,70,70
20070312,2330,1419.25,1419.25,1419.25,1419.25,50,50
20070312,2340,1419.25,1419.5,1419,1419.5,121,121
20070312,2350,1419.5,1419.5,1419.25,1419.5,60,60

all that needs to be done is in between each comma these numbers need to be put into a column
the first comma is the date, then time, open, high, low, close, then the other 2

but as there are nearly 200k of these it is impossible to do by hand. Does anyone have any ideas for a macro that could do this for me?

Thanks
Leon

Use Texts to Columns, and separate them by commas..

select the column
Click the Data tab;
Go to the Data Tools group;
There you will see the Text to Columns button.
click it
choose delimited
check the comma box
click finish