Select the cell and pull-down Edit Copy.
Then select an un-used cell and paste/special value.
Select the new cell and in the formula bar highlight the section of text you
want to format.

Format as usual.
--
Gary's Student


"TJ" wrote:

I am using the index formula to bring data to a sheet. I want to add a
superscript to text that will be adjoined to the formula.

=index(holdings!$b$4:$b$120,match($b9,holdings!$a$ 4:$a$120,0))&"(a)"

How do I superscript (a) in this case?