Results 1 to 11 of 11
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Can I Include Character Format In Formula Results (97)

    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
    Ronny Richardson

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Can I Include Character Format In Formula Results (97)

    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
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Can I Include Character Format In Formula Results (97)

    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.
    Attached Files Attached Files
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Re: Can I Include Character Format In Formula Results (97)

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

    Ronny
    Ronny Richardson

  5. #5
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can I Include Character Format In Formula Results (97)

    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

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can I Include Character Format In Formula Results (97)

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

  7. #7
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Can I Include Character Format In Formula Results (97)

    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!
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  8. #8
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Can I Include Character Format In Formula Results (97)

    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):
    <pre>Function SigmaSquared() As String
    SigmaSquared = ChrW(931) & ChrW(178)
    End Function
    </pre>

    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  9. #9
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Can I Include Character Format In Formula Results (97)

    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?
    -John ... I float in liquid gardens
    UTC -7ąDS

  10. #10
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Can I Include Character Format In Formula Results (97)

    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.
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  11. #11
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Can I Include Character Format In Formula Results (97)

    Copied it there and it doesn't run from there either. Wonder what DLL's it needs?
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •