I create simple xml data files in our product that are to be imported into Excel as XML Tables on different computers by customers throughout the world. One column is currently labeled: Tprime. But I want to modify the xml file so that column gets labeled: T’ So this is what I want to see after importing the xml file:

TPrime.jpg

There are several characters that would work for that prime character (beside the obvious single quote):
Prime character code 2032 = UTF-8 E280B2
Modified Letter Prime character code 02B9 = UTF-8 CAB9 or
Greek Tonos character code 0384 = UTF-8 CE84

My problem is that any of those characters generate an "XML Parse Error" during XML Import in Excel when they are used in the attribute name. I also get a verification error in other other XML verification tools. My reading of the XML 1.0 spec suggests that Modified Letter Prime character code 02B9 = UTF-8 CAB9 or Greek Tonos character code 0384 = UTF-8 CE84 should be valid for XML attributes, but they are not.

I can put any of those characters as XML attribute values, and they properly read in to Excel. For example, with this XML code:

C5TestCode.jpg

I get this result in Excel:

C5TestResult.jpg

So, The delta symbol is character code 0394, and that works fine in the attribute name. And the three prime characters I tried work fine as data values.
How can I get that Column A header to show T’ ?
Thanks for any help or suggestions.