Keeping text formatting when referencing a text cell

F

Frank Kabel

Hi
not possible with formulas and event not with VBA if you
want to update it automatically
-----Original Message-----
When referencing a text field in another column, the
Click to expand...
formatting of the content does not get copied over.
Example:
A1 (Text) This is formatted text data
A2 = A1

If "text data" in the cell is formatted as subscript and
Click to expand...
colored red, the contents of A2 contains only the plain
text.
How to get the contents of A2 to be the same as A1.......

I understand if I use the copy and paste (with paste
Click to expand...
special - all), the formatting is copied but I need to
find a automatic way to reference the contents while
keeping the original text format.
 
Top