Text Formatting to the Result of a Formula

[iv63]

=TEXT(A1,"0.0")&" x B2"
Is there any “trick” to format text created with this formula – I want number “2” to be exponent (subscript)?
Thanks,
IV

 

[joerd]

Not that I know of.
You may consider putting the [tt]=TEXT(A1,"0.0")[/tt] in one cell, and [tt]x B2[/tt] in the cell just to the right of it. Then you can format B[sub]2[/sub] whichever way you want.

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[Denial]

This can be done only for a vanishingly small subset of special cases, namely the exponents (ie SUPERscripts) 1, 2 and 3. The full ASCII character sets contain special characters for superscripted versions of these three digits, able to be generated by keystroke sequences Alt<0185>, Alt<0178> and Alt<0179> respectively (¹ ² ³).