View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TJ
 
Posts: n/a
Default How do I format text that is part of a formula?

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?