software

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))amp;quot;(a)quot;

How do I superscript (a) in this case?

Select the cell and pull-down Edit gt; 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 Studentquot;TJquot; wrote:

gt; I am using the index formula to bring data to a sheet. I want to add a
gt; superscript to text that will be adjoined to the formula.
gt;
gt; =index(holdings!$b$4:$b$120,match($b9,holdings!$a$ 4:$a$120,0))amp;quot;(a)quot;
gt;
gt; How do I superscript (a) in this case?

Hi TJ,
One way...
Enter the letter quot;aquot; in a superscript format in an unused, unseen cell,
e.g. ZZ1.
Go to ZZ1, select Format gt; Cells... gt; Font and check the superscript box.
The refer to ZZ1 in your formula.
HTH
--
Ken Hudsonquot;TJquot; wrote:

gt; I am using the index formula to bring data to a sheet. I want to add a
gt; superscript to text that will be adjoined to the formula.
gt;
gt; =index(holdings!$b$4:$b$120,match($b9,holdings!$a$ 4:$a$120,0))amp;quot;(a)quot;
gt;
gt; How do I superscript (a) in this case?

Thanks, but that does not allow the cell to update if the referenced cells
change.

quot;Gary''s Studentquot; wrote:

gt; Select the cell and pull-down Edit gt; Copy.
gt; Then select an un-used cell and paste/special value.
gt; Select the new cell and in the formula bar highlight the section of text you
gt; want to format.
gt;
gt; Format as usual.
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;TJquot; wrote:
gt;
gt; gt; I am using the index formula to bring data to a sheet. I want to add a
gt; gt; superscript to text that will be adjoined to the formula.
gt; gt;
gt; gt; =index(holdings!$b$4:$b$120,match($b9,holdings!$a$ 4:$a$120,0))amp;quot;(a)quot;
gt; gt;
gt; gt; How do I superscript (a) in this case?

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.

quot;Ken Hudsonquot; wrote:

gt; Hi TJ,
gt; One way...
gt; Enter the letter quot;aquot; in a superscript format in an unused, unseen cell,
gt; e.g. ZZ1.
gt; Go to ZZ1, select Format gt; Cells... gt; Font and check the superscript box.
gt; The refer to ZZ1 in your formula.
gt; HTH
gt; --
gt; Ken Hudson
gt;
gt;
gt; quot;TJquot; wrote:
gt;
gt; gt; I am using the index formula to bring data to a sheet. I want to add a
gt; gt; superscript to text that will be adjoined to the formula.
gt; gt;
gt; gt; =index(holdings!$b$4:$b$120,match($b9,holdings!$a$ 4:$a$120,0))amp;quot;(a)quot;
gt; gt;
gt; gt; How do I superscript (a) in this case?

On Thu, 29 Dec 2005 09:06:02 -0800, quot;TJquot; gt; wrote:

gt;I am using the index formula to bring data to a sheet. I want to add a
gt;superscript to text that will be adjoined to the formula.
gt;
gt;=index(holdings!$b$4:$b$120,match($b9,holdings!$a $4:$a$120,0))amp;quot;(a)quot;
gt;
gt;How do I superscript (a) in this case?

=index(holdings!$b$4:$b$120,match($b9,holdings!$a$ 4:$a$120,0))amp; char(170)--ron