pdsterling
Technical User
I have Windows XP Ver 5.1 SP 3, and Excel 2002.
From time to time, I receive a small database in text format, which is UTF-8 encoded and which contains a lot of foreign names and extended ASCII characters.
If I were to open this in my text editor, everything would look all right. If I convert the text to Windows ISO-8859-15, the extended ASCII characters turn to garbage.![[nosmiley]](/data/assets/smilies/nosmiley.gif "[nosmiley] [nosmiley]")
If I open the file directly into Excel, the extended ASCII characters are garbage. Its bad enough that half of my respondents list their home as Cologne and half as Köln, but having to fix K{expletive deleted}Ln repetitively is a drag!
I know there is a perfectly simple solution to this, however, I don't know that solution.
Any advice would be gratefully appreciated.
P D Sterling
Florida NY
From time to time, I receive a small database in text format, which is UTF-8 encoded and which contains a lot of foreign names and extended ASCII characters.
If I were to open this in my text editor, everything would look all right. If I convert the text to Windows ISO-8859-15, the extended ASCII characters turn to garbage.
If I open the file directly into Excel, the extended ASCII characters are garbage.
Its bad enough that half of my respondents list their home as Cologne and half as Köln, but having to fix K{expletive deleted}Ln repetitively is a drag!I know there is a perfectly simple solution to this, however, I don't know that solution.
Any advice would be gratefully appreciated.
P D Sterling
Florida NY