concatenate function limitations

[NITESH G]

How to format a text in concatenate function.
for eg. "mm2" . i want to do in concatenate function ,
the last no. 2 should be in superscript position.
pls suggest answer or alternative

 

[Roger Govier]

Hi

One way
with your number in A1 this formula in B1
=A1&" mm²"
to type the ², hold down the Alt key and type 0178 from the numeric pad, not
from the numbers on the top line of the keyboard. When you release the Alt
key, the ² symbol will appear.

Alternatively, Format>Cells>Number>Custom and in the white pane enter
General "mm²" again using Alt + 0178 to create the symbol.
The advantage of this method is that any number in the cell will still be
treated as numeric for further calculation, whereas in the first case it
would be text.