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

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!!

"thanksforthehelp" wrote in
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!!

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

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
"thanksforthehelp" wrote in
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!!

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.

"Jim Rech" wrote:

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
"thanksforthehelp" wrote in
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!!

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

"Fredrik Wahlgren" wrote:


"thanksforthehelp" wrote in
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!!

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