Opening CSV file(saved in unicode) in excel

  • Thread starter Thread starter Krishnakumar
  • Start date Start date
K

Krishnakumar

Hi,

If anyone can help me on this, I would really appreciate
that.

I have a file that is saved in .csv extension (Unicode
format). Let's say for example, I have the data as follows:

"text1","text2",123,"text3",450.00

When I save the above data in .csv (in Ascii format) and
open in excel file, I see that each value is placed in
adjacent columns.

When I save the same data in .csv (Unicode) I see the
whole information appears in the single cell(first cell
only).

Is there a limitation to the CSV FILE opening in EXCEL,
with Unicode format?

Any inputs/suggestions on this would be much appreciated
 
If the commas are still in the long strings perhaps you can do a Data, Text
to Columns. Indicate the data is Delimited and that the comma is the
delimiter.
 
Back
Top