Problem with combining cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining data from 2 cells into 1 cell 2
Excel Concatenate with line breaks but ignore blank cells 3
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Concatenation and Formatting 1
Sum the shown values of a cell 4
condionally formatting based on another cells formatting? 2
Set chart series endpoint dynamically 0
combining data in multiple cells 1

Back
Top