ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2003 and Unicode csv files (https://www.excelbanter.com/excel-discussion-misc-queries/166019-excel-2003-unicode-csv-files.html)

MarkR

Excel 2003 and Unicode csv files
 
I open Notepad, paste in "Zürich" (notice the accent on the u), File, Save As
test1.csv, change the encoding to Unicode and hit save. When I open that
file (by double-clicking it), Excel opens the file and it looks fine.

I open Notepad, paste in "Zürich" (notice the accent on the u), File, Save
As test2.csv, change the encoding to UTF-8 and hit save. When I open that
file (by double-clicking it), Excel opens the file and the accented u is
changed by Excel.

I am using Excel 2003 running on XP.

Anyone know if there is a way to open the UTF-8 file without that happening?


All times are GMT +1. The time now is 02:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com