How do I get superscript and reg in same cell

[yngpro59]

I am using Excell 2003. I am trying to put both regular and superscript text
into the same cell. The format seems to want either not both?

 

[Ron Rosenfeld]

I am using Excell 2003. I am trying to put both regular and superscript text
into the same cell. The format seems to want either not both?

If the contents of the cell is a text string, you can select just the part of
the string that you wish to superscript, and then format just that portion.

If the contents of the cell is a formula, then you will not be able to
differentially format the contents. However, depending on what you want
superscripted, there may be some font characters that you can use.

e.g: 2 -- abc²
a -- abcª
degree -- 47°C

etc.

Another option is to put the formula into a macro, which does the computation
and then writes a text string into the cell, formatted as you wish.
--ron

 

[Jim Thomlinson]

Highlight the text that you would like to be superscript. Right click the
text and select Format Cell. Select Superscript...

 

[Gord Dibben]

Select the cell.

F2 to edit.

In the formula bar select just the text to SS and format to SS


Gord Dibben MS Excel MVP

 

[Dave Peterson]

You may want to try John Walkenbach's utility:
http://j-walk.com/ss/excel/files/supersub.htm

And superscripting and subscripting only works on text values -- no real numbers
and no formulas.

Numbers used in text strings will work fine.