Can I Include Character Format In Formula Results (97)

Topic

New Reply

I have a worksheet tab that computes the endpoints of a variance confidence interval in cells B7 and B8. I would like to display the results as a confidence interval using the formula:

=&B7&”s2″&B8

where the s is replaced with a sigma symbol (I can do this but cannot show it here because the sigma does not paste) and where the 2 is a superscript. I can make the 2 a superscript in a text cell but not where it is part of a formula.

I tried putting the s2 in another cell and superscripting the 2 there and then using the formula

=&B7&C10&B8

but that did not bring the formatting forward.

Is it even possible to superscript the 2 in the results? Is so, how?

Ronny

Reply | Quote

Replies

Don’t use formatting, instead in Word, use the Insert | Symbol | Normal Font to place both the sigma and the squared into the document. The squared is on the fifth line, just after the plus-or-minus. Copy these two characters from Word to your Excel formula. HTH –Sam

Reply | Quote

This is a pain in the Excel. I cheat and get the symbols in Word using the same font I’m using in the spreadsheet. See attached. In this case since you wanted superscript, I used the “squared” symbol, if you wanted subscript I don’t know how that can be done.

Reply | Quote

What a simple and neat solution. Works like a champ. Thanks.

Ronny

Reply | Quote

You can use the Charater Map too to find your symbols, this will also give you their Key Stroke number – “alt 0178” for the superscript 2. These can be entered directly into the edit line

HTH

Peter

Reply | Quote

Just use the Character Map program to copy and paste the sigma and squared symbol and paste them between your quotes.

Reply | Quote

For those dodos like me who thought that Character Map went away when they abanded their Mac, it’s under Programs | Accessories | System Tools in Win2000, or in Accessories in NT and 95. I’m not telling how many times I’ve taught Windows but didn’t know about Character Map. Thanks for the tip, Legare!

Reply | Quote

I usually go to Word because I don’t have CharMap available anywhere except through Explorer. When I went to refresh myself on using it on W95 platform, I found it in C:Windows, but it won’t run. Any obvious reason why?

Reply | Quote

On Win95, Character Map should be in Programs | Accessories, but that vintage of Character Map only displays the first 224 characters, so you can get the squared character but not the sigma.

Reply | Quote

Copied it there and it doesn’t run from there either. Wonder what DLL’s it needs?

Reply | Quote

Hi,
If you need to do this a lot, the following user defined function will return the characters you want (at least, it works in Excel2k on Win2k – I can’t test it on anything else):

Function SigmaSquared() As String
   SigmaSquared = ChrW(931) & ChrW(178)
End Function

Hope that helps.

Reply | Quote