I'm working with Excel to open a delimited (tabbed) txt file that contains Portuguese and Spanish accents. As you can see below, in the third row there is a title "Último Año" that is correct.
However when I import the file into Excel the text is misinterpreted as "Ãšltimo AÃ±o".
The correct codepage would be Unicode UTF-8 or ANSI. I tried several options, like using the import file options from Excel to select UTF-8 (and other formats) but the result is always weird.
Does anybody know how to interpret/display the correct latin accents on Mac Excel?