Opening CSV file(saved in unicode) in excel

[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

 

[Jim Rech]

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.