Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 23
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 364
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
character map bushy Excel Discussion (Misc queries) 1 May 29th 08 09:27 AM
Character Steved Excel Worksheet Functions 3 February 22nd 07 09:04 PM
Excel-Match 1st text character in a string to a known character? bushlite Excel Worksheet Functions 2 January 15th 07 06:36 PM
Can I create a special character for the Character Map? JohnP Excel Discussion (Misc queries) 3 December 24th 06 01:10 AM
If Character #8 = C Wes Paul Excel Worksheet Functions 2 February 4th 05 07:50 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"