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

This was similarly asked and answered before: Excel to CSV with UTF8 encoding. Take a look at Eric's answer.