Posted by Erwin Moller on 05/11/05 13:10

Jason F. wrote:

> Erwin Moller wrote:
>> In excel you can go to a cell, and use ALT-ENTER to give a newline INSIDE
>> a cell.
>>
>> How to mimic this in a CSV-file??
>
> I don't see the problem:
>
> worksfine.csv
> ------------------
> "foo","bar"
> "col1 on one line", "col two
> on
> four
> lines"
> ------------------
>
> The above multiline CSV displays as intended in OpenOffice and MSOffice.

Thank you Jason,

I found out that that works perfectly for me too: On W2000 with Excel 2000.
But it is not working in Excel 2002 on XP (So I understood, I don't have it
at hand.)
It seems that different versions of Excel treat CSV files different. :-(

Regards,
Erwin

[Back to original message]