cell referencing

[lester5678]

I would like to be able to reference the contents of one cell into another without losing such formatting as subscripts and superscripts, italics, etc.

Currently, if cell A1 contains a string of characters with a superscript or subscript and I reference it into cell A2 using =A1 or =$A$1, the formatting is lost.

 

[Von Pookie]

There is no way to do that with a formula.