0

I'm working with population data in Vietnam. I've downloaded a series of cities and their corresponding population densities on the NASA SEDAC website. The issue is when I open the document, all the Vietnamese names are in symbols, maybe due to the different alphabet. Is there a way to make the symbols change into their corresponding letter?

enter image description here

3
  • Use a font that supports those characters. Also make sure your are using the correct text encoding Nov 13, 2019 at 16:12
  • It may be more than just switching to a supporting font: the NASA database may have mangled the encoding and the export may have mangled the encoding. So if you use a typeface with vietnamese support and still see glyph issues, look into the encoding and code page on the NASA database and also the format used for export.
    – Yorik
    Nov 13, 2019 at 16:15
  • 1
    @Guillaume You can answer your own question - you should turn your comment into an answer.
    – DavidPostill
    Nov 13, 2019 at 17:30

1 Answer 1

0

I opened a blank excel doc, went to "Data" > "Select from text" > Went to chose my Vietnamese Excel Doc --> Import. Then a dialog box opens: in the top left dropdown list entitled "origin of folder" select "none". My symbols were transformed in english letters

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .