how do i superscript part of a cell in MS Excel?

[allan]

When I use the superscript option after selecting just a portion of the cell,
the superscript appears during edit mode only. How do I get it so it appears
as superscript on the spreadsheet or when printing? Again, I'm only trying
to superscript part of a cell's contents, not the entire cell.

 

[Dave Peterson]

Did you hit enter have you applied the format change?

And you can't do this kind of formatting to formulas or real numbers.

It has to be text.

If you do this a lot...

John Walkenbach has a helpful addin that you may like:
http://j-walk.com/ss/excel/files/supersub.htm

 

[allan]

I hit enter and it went to being "non-superscript," even though it appears as
superscript in the edit mode. I am trying to do this with text. The format
cells window show it as being formatted with a square or circle, rather than
the checkmark when I look at the particular cell. Thank you for the advice.

 

[Dave Peterson]

What's in the cell?

What character in that string are you trying to make a superscript?

What font are you using (for all the string or for that character)?

What version of excel are you using?

I've never had any trouble with plain old text (but that doesn't help you).

 

[allan]

Thanks, againl, for your advice. I have written "Land (1)" in the cell since
I can't superscript. I would like to have something like Landa, with the "a"
super script. I've tried it as part of a string and seperately, with no
success. I'm using MS Excel 2003, and I'm not sure why I'm having these
problems. I know I've done superscript using (format, cells, font, effects)
in an earlier version of Excel I have at home. It doesn't seem to work with
numbers, symbols, or letters on my particular system at work, which should be
a far better system than I have at home. I'm just using plain, old, regular
Arial font- nothing fancy. It's a very standard document/sheet.
Again, the superscript does appear while in "edit" mode (double click, F2),
but it disappears once I disengage that (enter, tab, green check). It does
remember, however, that it's there because it's still superscripted each time
I return to edit mode on that particular cell. I've resorted to using the
(X) in the meantime. I did download and use the add-in you recommended, but
it did the same thing (superscripted only in edit mode). Thanks for your
help. It may just be the system I'm on, though I'm not exactly sure why.

 

[allan]

Dave, sorry about all the trouble. I was using data that someone else had
sent to me and I was modifying into financial statements. I'm not sure
exactly what formatting they had applied to the affected cells, but I did
(edit, clear, format) and I was able to do superscripts again. Thanks so
much for your help!

 

[Dave Peterson]

Thanks for posting back.

If you find out what they did, post back (I don't have a guess).

Dave, sorry about all the trouble. I was using data that someone else had
sent to me and I was modifying into financial statements. I'm not sure
exactly what formatting they had applied to the affected cells, but I did
(edit, clear, format) and I was able to do superscripts again. Thanks so
much for your help!

 

[allan]

I don't have good enough a connection with the spreadsheet's source to find
out what they did, but I wasn't able to identify anything on my own (i.e., it
wasn't a special font or anything). Sorry.

 

[Dave Peterson]

No problem. I just chalk it up to magic. (a very big category!)

I don't have good enough a connection with the spreadsheet's source to find
out what they did, but I wasn't able to identify anything on my own (i.e., it
wasn't a special font or anything). Sorry.