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

Combining 2 Formulas 1
Format linked workbook cells (updated) 2
Event macro to extract data based on value of 2 cells - help 1
Superscripting text in a cell 1
Swap 2 ranges 3
syntax for "IF" commend to check for multiple empty cells bf comma 4
Conditional Formatting > 3 conditions & referencing cell values 3
Set default cell format while retaining overrides 3

Top