Excel to Tab delimited (.txt) file with special character

Question

I want to export Excel to Tab delimited (.txt) file with special character.

I've changethe format to UTF-8, but it still doesnt work.

The origin data is like Mädchen and what i got is M?dchen

Anyone can help me? Thank you

Answer 1

The best way to do it is to save the file as an Unicode text file. And save as the unicode text file, change the encoding to utf-8