2

I have an interesting situation in Excel 365.

I one column I have phone numbers of my contacts. By looking in a cell it looks like this:

+xxx‎31417728

But when I export file as text file TAB delimited, the same number turns into:

+xxx?31417728

Please notice the question mark, which is not visible in a cell.

What is the issue? How to show these kind of hidden characters in Excel?

Thanks.

  • what happens if you convert the column to text before you export? – Albin Jan 9 at 17:42
0

Excel exports text files with Windows-1252/CP-1252 character encoding.

https://stackoverflow.com/a/50653812/148844

So if you have a UTF-8 character that does not fit within the Windows-1252 character set, then it will be exported corrupted.

There is no known way to export text files correctly with Excel because it is a known bug with no UTF support, as you can see from the thousands of answers I linked to.

Some alternative ways to export is to copy & paste to Google Sheets then export a TSV or use Open Office to read the Excel file and export with UTF8.

Sometimes UTF has non-printing characters to control where diacritical marks show and join separate letters into one in other languages.

https://en.wikipedia.org/wiki/Control_character#In_Unicode

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.