Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Character Set
I haven't seen this talked about recently. Periodically, I get a small
database in UTF-8 encoding. When I upload it to Excel, I get garbage for such characters as ü, é, â, and many more. I experimented, opening it in a text editor, and it read correctly, but when I asked the text editor to convert it to Windows ISO, the accented characters became garbage. It wouldn't be such a problem, but sometimes I don't know that "L!@#$%vis" means "Lévis," if I have never heard of the place! I tried the help function, but all the available comments were *un*helpful. Any assistance would be gratefully appreciated. -- Regards, P D Sterling Florida, New York USA |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Character Set
Can you send the data you get to me (few rows of data would do...)?
What is the Font being used? Which version of Excel are you using? "P D Sterling" wrote: I haven't seen this talked about recently. Periodically, I get a small database in UTF-8 encoding. When I upload it to Excel, I get garbage for such characters as ü, é, â, and many more. I experimented, opening it in a text editor, and it read correctly, but when I asked the text editor to convert it to Windows ISO, the accented characters became garbage. It wouldn't be such a problem, but sometimes I don't know that "L!@#$%vis" means "Lévis," if I have never heard of the place! I tried the help function, but all the available comments were *un*helpful. Any assistance would be gratefully appreciated. -- Regards, P D Sterling Florida, New York USA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
character map | Excel Discussion (Misc queries) | |||
Character | Excel Worksheet Functions | |||
Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
Can I create a special character for the Character Map? | Excel Discussion (Misc queries) | |||
If Character #8 = C | Excel Worksheet Functions |