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;

enter image description here

I have even tried putting the mm^2 text in its own cell and referencing that in the formula but still no joy.

1 Answer 1


Instead of superscripting the normal 2, use the dedicated character, which is common to most fonts. Windows character map

  • 1
    found on most azerty keyboards next to the 1 button Sep 19, 2014 at 14:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.