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:
But when I export file as text file TAB delimited, the same number turns into:
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?