0

I have a tab-delimited text file which contains dagger characters (†). When I open this in Excel 2010, they are mangled and replaced with † (I'm not sure if Excel is adding the space, too). Why does this occur and how can I fix it?

Right now I do search and replacing in Excel to replace the †s, but it's inefficient for many files and hacky.

Superbest
  • 25,318
  • 14
  • 62
  • 134

2 Answers2

1

The original file is not using the character encoding that Excel expects.

See

Character Encoding and the ’ Issue

Excel's Import Wizard is better at handling encoding issues and may be able to open your source file properly. See

Microsoft Excel mangles Diacritics in .csv files?

Community
  • 1
  • 1
Eric J.
  • 147,927
  • 63
  • 340
  • 553
0

Nevermind, after taking another look at Open .csv file containing special characters in Excel I realized that instead of Right Click -> Open with Excel, if I go to File -> Open in Excel it lets me choose the encoding.

Community
  • 1
  • 1
Superbest
  • 25,318
  • 14
  • 62
  • 134