Diacritical Marks – how to fix them in Excel

Does this look familiar? The problem with Diacritical Marks Diacritical marks are the symbols that many languages add to letters indicating a different pronunciation. Examples of words diacriticals can be found in French, German, Spanish, Italian, Portuguese, Polish, Czech, Swedish, Norwegian and others. Take for instance: “geïnspireerd” in Dutch, “språk” in Swedish or “hören” in German. The issue with these diacritical marks is that programs like Excel and Word sometimes mix them up. This guide shows you how to solve this issue! When you export a text file with diacritics to Excel you often end up with a list like in the image above. Don’t worry though, you don’t have to manually correct all these words! There is a simple way of fixing them.

Step 1: open the file in Notepad

 

Step 2: save as – change the coding ANSI to UTF-8

Save the file as a Notepad file using the ‘save as’ option, be sure to change the coding from ANSI to UTF-8. save as  

Step 3: open the file you just created with Excel

Go to the text file you just created, and open it with Excel. The import Wizard will pop-up. öppna  

Step 4: Work your way through the Wizard

save2  

Step 5: Finish the Wizard

finish  

Step 6: Done! Save the file in the Excel format (.xlsx)

If you now open the file you will see that all diacritical marks appear correctly. done Other helpful links:

Warning: Invalid argument supplied for foreach() in /home/copypanthers/public_html/wp-content/themes/copypanthers25/inc/shortcodes/feed.php on line 58

Reviews from Crowdpanthers

News Feed