How do I format text that is part of a formula?

T

TJ

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?
 
G

Gary''s Student

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.
 
K

Ken Hudson

Hi TJ,
One way...
Enter the letter "a" in a superscript format in an unused, unseen cell,
e.g. ZZ1.
Go to ZZ1, select Format > Cells... > Font and check the superscript box.
The refer to ZZ1 in your formula.
HTH
 
T

TJ

Based on the formula I am using (see below), how could I reference the cell
with the superscript a? I tried concatenate, but received N/A.
 
R

Ron Rosenfeld

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?
Click to expand...

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


--ron
 
Top