Results 1 to 4 of 4

Superscript text formatting in a formula

This is a discussion on Superscript text formatting in a formula within the Excel Questions forums, part of the Question Forums category; Hi all I have a formula that pulls through a text string and puts '(1)' at the end of it. ...

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    64

    Default Superscript text formatting in a formula

    Hi all

    I have a formula that pulls through a text string and puts '(1)' at the end of it. I want to format the (1) as superscript. If I had typed just text into a cell this is simple to do, but as this is a formula you cannot format a part of the text string just by selecting format cells. The formula I am using is as follows:

    =Prior_Period&" (1)"

    Is it possible to use the following? If so how can I format as superscript!?

    =Prior_Period & Text(" (1)",[format as superscript])

    Any help or thoughts would be appreciated.

    Thanks

    Chris

  2. #2
    MrExcel MVP tusharm's Avatar
    Join Date
    May 2002
    Posts
    10,923

    Default Re: Superscript text formatting in a formula

    AFAIK, differently formatting a part of the result of a formula is not possible. Can you use an adjacent cell and format that cell itself?

  3. #3
    MrExcel MVP
    Moderator
    Scott Huish's Avatar
    Join Date
    Mar 2004
    Location
    Oregon
    Posts
    17,074

    Default Re: Superscript text formatting in a formula

    If it is always a 1 that you want superscripted, you could try the following:

    =Prior_Period & CHAR(185)

  4. #4
    Board Regular
    Join Date
    Jan 2004
    Location
    Melbourne
    Posts
    3,459

    Default

    So for your example, you would need:

    =Prior_Period&" (" & char(185) & ")" to get the brackets
    There are three kinds of people - those that can count and those that can't.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com