Hi everyone!

Im really stuggeling with excel. I do know how to import txt-files from web into excel, but when i do, the charset is wrong. So the Norwegian letters ÆØÅ is now wierd symbols (Ã¥Ã). This is not the case if im importing the text-file from a local folder.

I cant find any option for this in excel. I have been searching for a way to change the import settings to UFT-8 charset. Do anyone have an idea what to do?

Tord

In 2003 go to Tools, Options, General. Click on the Web Options button and go to Encoding. Click on the list and you will see UFT-8 (probably just up a few items.) Select that, then click OK, OK.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.