SPLIT number

Hi everyone,
I'm trying to do this : SPLIT number in cell A1 like this using function
A 1 _______ B 1 ___ C 1 ___ D 1 ___ E 1 ___ F 1 ___ G 1 ___ H 1
12/29/2007,40.00,40.50,33.70,37.80,205010920,37.80 _____ 12/29/2007 ____ 40 _____ 40.5 _____ 33.7 ___ 37.8 ___ 205010920 ___ 37.8

Thanks in advance for all your help!!

Bro.....
Just take some pain and upload the same in workbook with expected result.....

nubie here try to answer

Do you mean UDF Function?

Please Login or Register  to view this content.

how it work:
in cell B1 type =strsplit(A1,1,",") it will get 12/29/2007
in cell C1 type =strsplit(A1,2,",") it will get 40.00

and so on..

Or do you want to select the range to split ?

Please Login or Register  to view this content.

how it work?
just select the cells range in column A, then select where do you want to put the result , example in B1