Excel parsing unicode csv file

  • Thread starter Thread starter comet61
  • Start date Start date
C

comet61

I have a unicode csv file, which has text fields within double quotes, that
contain carriage returns. When I try to open this in Excel, Excel interprets
this as a new cell. How do I fix the csv so that all the text within the
double quotes stays in one cell?
 
I should add that when I save it as ANSI, there is no problem with the field
discussed below. I also have used the Excel parsing wizard to no avail.
 
Back
Top