How do I copy a cell with effects?
 

I am trying to copy a cell that has both regular text and subcripts
(effects). When I copy it, the new cell only shows regular sized text. I am
trying not to retype these cells because my program is rather lengthy and if
a title changes, I would like all of them to change in the subsequent pages.

I am using Excel 2003.

Thank you.

How do I copy a cell with effects?
 

[a1].Copy [E1]

copied correctly i.e. A1 had superscript or subscript (7th with "th" as
either super/sub)

XL2003

"avsmith" wrote:

I am trying to copy a cell that has both regular text and subcripts
(effects). When I copy it, the new cell only shows regular sized text. I am
trying not to retype these cells because my program is rather lengthy and if
a title changes, I would like all of them to change in the subsequent pages.

I am using Excel 2003.

Thank you.