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

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Problem in reading .csv file with unicode characters 1
Excel CSV Files; Creating Of 3
Excel won't open Unicode CSV file from SQL Server 2
Missing double quotes when opening .CSV file from notepad 1
Opening CSV File 1
Creating a csv 4
dump a multiple sheet excel file to a single text file 3

Top