Diacritical Marks and Blank Spaces Not Appearing Properly in

TASHFIN

New Member
Joined
Mar 16, 2002
Messages
22
I have received an Excel file which was sourced from a file which had "diacritical" marks in their names like "ÖAF, Mégane" - Now the problem is when I open the file in Excel - what I get is for example with Mégane
is "Mtgane". Also in the file where he had blank spaces I am getting on opening the file
a funny a ( Á )

The person who sent me this file eluded to the fact that as I am based in Europe I could be using a differnt Code Page system for Windows.In US apparently the Code Page is 1252 while in Europe it is 850. Only Bill Gates could come up with that kind of genius
system.

Now I don't have a clue about different Code Pages - but short of replacing my windows version - can someone recommend a procedure to open the file with Diacritical marks and for the blank spaces to appear properly ?

Thanks
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

shades

Well-known Member
Joined
Mar 20, 2002
Messages
1,550
Well, I don't have many answers but a few questions. (EDIT: I should probably read the title as well :wink: )

You might be able to determine the coding (if Windows 2000 and Office XP) by going to Character Map (Program > System Tools) and then checking the coding (usually set to Unicode in Windows 2000); but there are other codings listed in the drop-down box. That may give you a hint to find the character and then do a Find and Replace.

Might not be much help, but worth examining.

_________________
- old, slow, and confused
... but at least I'm inconsistent -
This message was edited by shades on 2002-10-15 16:57
This message was edited by shades on 2002-10-15 17:02
 

Forum statistics

Threads
1,181,580
Messages
5,930,725
Members
436,757
Latest member
Marijn

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top