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

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

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,144,274
Messages
5,723,442
Members
422,497
Latest member
dougy99

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