Problem with combining cells
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 |
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 |
All times are GMT +1. The time now is 05:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com