Excel parsing unicode csv file

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?
 
C

comet61

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top