I have a formula which I want to show a result which includes a superscript character, but I cannot get said character as superscript.
Normally I would just enter text into a cell and I can select just the character I want superscripted, right click, Format Cells
and choose Superscript
. However the Format Cells
option is greyed out when I have a formula in the cell.
The formula in question is along the lines of;
="Area = "&A1"&"mm2"
To ideally give me an output of;
I have even tried putting the mm^2 text in its own cell and referencing that in the formula but still no joy.