Problem with combining cells

Y

yhm

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
 
C

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
Top