Superscript text formatting in a formula

[chris-evans]

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

 

[tusharm]

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?

 

[Scott Huish]

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

=Prior_Period & CHAR(185)

 

[tactps]

So for your example, you would need:

=Prior_Period&" (" & char(185) & ")" to get the brackets