You could use the camera tool

"Bender" wrote:

When copying a cell with mixed format

i.e. H2O with the 2 in subscript is in cell A1,

If another cell contains =A1 the subscript format on the 2 is lost and H2O
is displayed. Is there anyway other than copy and paste to retaing the
formatting?