One way would be to Copy PasteSpecial Values on the cell and then
re-format for the superscript 3

Vaya con Dios,
Chuck, CABGx3




"yhm" wrote in message
...
Hi,

Am wondering if anyone has tried this before. I would like to combine the
contents of two cells into one.

Eg: Cell C3 = 25 and cell D3= kg/m3.

The number 3 in cell D3 is in subscript format. However, when I combine
the
cells using "Concatenate" or "&" function, the formatting for the
subscript
is lost.

Is there anyway I can do this? ;-D