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?