Menu, Data , Convert...
Yes, it's tricky and annoying.
If you have just used the Menu, Data , Convert... in XL2003
then the next csv file you open will magically spread itself into 3 cloumns.
As if X knew you wanted it like that.
However if you close Excel, it seems to forget.
So, do it once and it will remember.. until you next close XL.
G.
"Roman" <rgelfand2[ at ]hotmail.com> a écrit dans le message de news:
1156368648.650220.315620[ at ]p79g2000cwp.googlegroups.com...
[Quoted Text] >I have an xls file with worksheet made up of 3 columns of data. I save
> it in Excel 2003 as csv file. When I open the csv file, the columns
> are lumped into one column.
>
> When I do the same thing in Excel 2000, 3 column appear and this is the
> desired result.
>
> How do I make 3 columns appear in excel 2003?
>
> Thanks in advance
>
|