I have to put this file into excel
http://www-personal.buseco.monash.ed.../data/wine.dat


When I do that every figure is located in colom A while in fact onl
the first colom had to be in A and the second colom had to be in colo
B and so on. Can somebody help me please

thank you a lo

--
Palliete
-----------------------------------------------------------------------
Pallieter's Profile: http://www.excelforum.com/member.php...fo&userid=2778
View this thread: http://www.excelforum.com/showthread.php?threadid=47293

Hi

Mark the whole of column A
Choose Data>Text to Columns>Delimited>select Space as the Delimiter and
press OK>OK

Regards

Roger Govier



Pallieter wrote:

>I have to put this file into excel:
>http://www-personal.buseco.monash.ed.../data/wine.dat
>
>
>When I do that every figure is located in colom A while in fact only
>the first colom had to be in A and the second colom had to be in colom
>B and so on. Can somebody help me please
>
>thank you a lot
>
>
>
>

Try using Data>Text to Columns... set it as Delimited and use Space as
the delimiter.

Good Luck


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=472934