CODEWITHSUNDEEP
c#asp.netexcelexcel-2010
ScrumGuy000
ScrumGuy000

Reputation: 21

Strange symbols appearing in Excel CSV export after bullet points

I have written a method to export data in a CSV format to Excel. Most people's Excel document look fine, however some Excel documents have a question mark in a box symbol after the bullet points in one of the columns. The data is exactly the same people are looking at. Is this something I can fix in the code, or is there a setting that needs to be changed in Excel to not display these strange symbols after bullet points?

Upvotes: 0

Views: 2690

Answers (1)

Joel Etherton
Joel Etherton

Reputation: 37543

This usually means there is a symbol that the default font on the user's system is unable to interpret. Since CSV is raw text, your 2 choices are:

  1. Find the symbol causing it and replace it with a more friendly (universal) symbol
  2. Encourage users to use a specific font that has a larger character set (Arial/Verdana/etc).

Upvotes: 2

Related Questions