How do I use superscript font in text from a formula

[spurs]

If I am typing for example
in2 in a cell without an equal sign in front of it, I an adjust the font to superscript the 2 so it appears as squared insead of in2 (this forum wont let me superscript)
once that cell is formatted and working properly, if i merely put an equal sign in front of it and quotations for text ie ="in2" the 2 is no longer superscript and i cannot find a way to control it to superscript to a sqquare

Anyone have insight as to how to do this?

 

[Anthony47]

For superscript 2 and 3 you can use CHAR(178) and CHAR(179)
For superscript 4 to 9 you can use UNICHAR(xxxx), with xxxx ranging from 8308 to 8313

Samples of formulas are in the attached XL2BB minisheet; its rendering is in the attached image (but it seems ok also in the XL2BB minisheet)

You may find the list of Superscript and Subscript unicode coding here: Superscripts and Subscripts (Unicode block) - Wikipedia

Cartel7
	A	B	C	D
1
2	in²	="in"&CHAR(178)
3	in³	="in"&CHAR(179)
4	in⁴	="in"&UNICHAR(8308)
5	in⁹	="in"&UNICHAR(8313)
6
7
Foglio2

Cell Formulas
Range	Formula
A2	A2	="in"&CHAR(178)
A3	A3	="in"&CHAR(179)
A4	A4	="in"&UNICHAR(8308)
A5	A5	="in"&UNICHAR(8313)

 

[spurs]

Thank you. What about -1 as a power including the minus sign?

 

[Domenic]

Try...

="in"&UNICHAR(8315)&CHAR(185)

Hope this helps!

 

[spurs]

Thank you. I have been wondering how to fix this for a long time!

 

[Domenic]

You're very welcome, cheers!