| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| autofilter problem | Excel Worksheet Functions | |||
| Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
| problem with cells | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
Linear Mode
