Converting excel to .txt file and having superscript or subscript show differently

I am trying to convert an excel file into any txt or csv file that will actually show a superscript or subscript differently. Just needs to be some kind of indicator there for me to identify it was truly a special character...

I briefly looked at some Unicode and this may be the answer but not sure how to get this to work.

So if I have the number 2 raised to the 2 power, we would show it as 2² as a superscript in one of the excel blocks. Now if it needs to be some kind of math formula conversion that is fine. I am just trying to convert "2²" into something that isn't simply "22" when viewing it as the text file after doing a save-as.

Basically I am writing a c++ program that takes each data and reads it in a variable and manipulates the data to output something else. The data I am reading is entered into excel by other users but my output will not need to deal with excel. Once I read-in the data...excel is out of the picture. So writing my program in Visual Basic is not the goal.

If saving as Unicode or some other means has a way of identifying this special character by using unicode or something like 2X2...my program can take this data and handle it the way I need.

My problem is I want to take a native excel file with no special visual basic/macros...and simply do a save-as with some configuration options possibly?

If need be, we can enter this superscripts/subscripts in a special manner if need be.

Thanks in advance for your help.

This solves my issue but presents a new one.

When using the "symbol" superscript the number comes in a lot smaller then using the method of:

1. Type in the number
2. right click and select format cells
3. click superscript under "effects"

I attached the image that shows the size difference. Even when increasing the font of this "symbol" it never really sizes to the original way we do superscripts.

Is there anyway to match this image. The top number is the way we normally do superscripts. The bottom number is the way the superscript looks when inserting a symbol.


2016_02_12_15_23_25_test.xlsx_Excel.png

No I do not need the font to carry over into my txt file. Inserting it as a symbol truly fixes my txt file issue.

I am only looking at this as an aesthetics situation now. It just looks smaller and someone said they have concerned that its a little too small.

It just seemed weird that excel is treating the two superscripts differently.