How do I link cells and keep the formating in excel?

[Guest]

I don't know how to link a cell and the formating from one cell to another.
I am trying to link a cell that has text with a superscript (like k^4).
Currently, the linked cell would just show it as text (i.e. k4). Can I
create a smart tag for this? Do I need to make a macro to do this? Can I
make an autocorrect for this?

Please help!!

 

[Fredrik Wahlgren]

I don't know how to link a cell and the formating from one cell to another.
I am trying to link a cell that has text with a superscript (like k^4).
Currently, the linked cell would just show it as text (i.e. k4). Can I
create a smart tag for this? Do I need to make a macro to do this? Can I
make an autocorrect for this?

Please help!!

Copy the cell with the superscript. Then Select Paste Special and make sure
All is selected. I tested this with a string where portions of it was bold.

/Fredrik

 

[Jim Rech]

Cell formats are not referencible (if that's a word) by formula. And in
Excel it is simply not possible to give a formula cell a mixed text format
like you want to do. Mixed formats are only possible with pure text
entries. Sorry.

--
Jim
message |I don't know how to link a cell and the formating from one cell to another.
| I am trying to link a cell that has text with a superscript (like k^4).
| Currently, the linked cell would just show it as text (i.e. k4). Can I
| create a smart tag for this? Do I need to make a macro to do this? Can I
| make an autocorrect for this?
|
| Please help!!

 

[Guest]

I was afraid that was the case. Excel should make that an option in their
next release. I don't see why it is not availible.

 

[Guest]

That does work, but I want it linked so if I change the one cell the other
cell(s) changes automatically. Thanks.