Excel 2007 : how to get columise data out of raw data

[mailview]

Hi
I have a sheet 1 with raw data such as bellow

Date Day Time Number Place Duration Cost

08/04/10 Thu 13:55 07967408575 0:02:47 0.000
From a website and now what i want to do to make a excel sheet where if in sheet 1 i insert the raw data in to one for example in A 1

then in sheet 2 is should appears as in colums sepratly raher then just a raw data

see the attachment
please help

[JBeaucaire]

Copy the formulas shown down as far as you'd like. As you add data to Sheet1, sheet2 will parse out you entries.

[mailview]

Thanks mate you are a start
but

I tried your solution but it has a bit issue in it can you please have a look and tell me what to do
see the attachment
ta

[JBeaucaire]

Try this....