Combining 2 Cells and retaining format of each?

L

Lance Hoffmeyer

I have one cell which is
=Mean!D9 with a value of 5.2
and another cell which is
=Charcode!D9 and is an IF formula
containing blanks,A,B,C
and the cell formatted as a superscript



I wish to create a third cell combining these two cells,
while retaining the format of the superscript cell.
I have tried =Text(Mean!D9,"0.0")&Charcode!D9
which combines the two cells but it does not retain the
subscript format of the Charcode!D9 cell. Is there a
way to do this?

Lance
 

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

Superscripting text in a cell 3
Summing a range of cells based on criteria in another range 2
EMail to an address in a cell 4
how to count this in this unusual situation 2
ActiveCell.FormulaR1C1 4
Format linked workook cells 0
Combining 2 Formulas 1
Cond. Form. Adding In dates & out of dates 0

Top