preserving text formatting in formulas

[Pray4Snow]

Howdy,

I have a text string in a cell, which has some minor formating (a
subscripted letter).

When I refer to this cell in a concatenation formula (ie. =A1&B1 ... or
=concatenate(A1,B1) ... etc.) the subscripting is lost.

Is there a way to preserve the formatting from the source cell in the output
cell?

Thanks,
Jamie

 

[hgrove]

Pray4Snow wrote...

I have a text string in a cell, which has some minor formating (a
subscripted letter).

When I refer to this cell in a concatenation formula (ie. =A1&B1
... or =concatenate(A1,B1) ... etc.) the subscripting is lost.

Is there a way to preserve the formatting from the source cell in
the output cell?

No, at least not directly and not without VBA.

You could fake this using an intermediate cell ideally in a hidde
worksheet to hold the formula, then using a Calculate event handler t
create the desired formatted result as a linked picture in the desire
cell, but this is fragile and the VBA is nontrivial