Thread: How do I format text that is part of a formula?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld
 
Posts: n/a
Default How do I format text that is part of a formula?
On Thu, 29 Dec 2005 09:06:02 -0800, "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?

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


--ron
Reply With QuoteReply With Quote