You cannot specify any formatting in a formula. The result of a
formula is always unformatted.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com







"Michael" wrote in message
...
I would like to display numbers as subscript within a
combination text-number
string (but solely the numbers). This is generally important
for aesthetic
appeal and legibility.

Example: I'd like to automatically generate the formulas for
hydrocarbons
(i.e. Ethane, C2H6) where the numbers appear in subscript
format. To do this,
I have a counter for Carbons 1-100, and a formula for Hydrogen,
2*C+2 (where
C stands for the number of carbons). Then I use the command

=Concatenate("C",$C2,"H",$H2)

And out pops C2H6. However, I'd prefer this to display in a
neater format. I
do not see a command for this. Does anyone have any
work-arounds?