Problem superscript in formula

[kevinadrideo]

Helle,

I want to put a superscript in a formula.
I write :
=UPPER(RES_RISK_ANALYSIS) & SetSuperScript(1)

But the result is : RISK_ANALYSIS¹

How can I have : RISK_ANALYSIS ⁽¹⁾ ?

I can't use parenthesis in superscript with a formula

I need some help please

[Norie]

Have you tried passing (1) to the SetSuperScriptFunction?

[kevinadrideo]

Yes I do. but the result missing parenthesis in the superscript...

[Norie]

Can you post the code for the SetSuperScript function?

[kevinadrideo]

So, setsuperscript is an Excell function
more widely, I want to write a formula with a footnote. And the note footer must contain parenthesis.
For exemple : If I write : = 2 +3 ⁽¹⁾
I want : 5 ⁽¹⁾
the problem is that when I test different formula, I get 5 without parenthesis as : 5 ¹
While I want parenthesis in superscript.

Thanks

Kevin

[martindwilson]

setsuperscript() is a function? where is that then ,i've never seen it are you sure its not an UDF?

[Norie]

Kevin

Where does this function SetSuperScript, UDF or otherwise, come from?

I'm pretty sure it's no a native Excel function and I can't seem to find it anywhere else.

PS Have you tried enclosing (1) in quotes?

[kevinadrideo]

So,I've this function in my Excel. I don't know if it's a native function or not...
I Try to enclose (1) in quotes but the result is 1 without parenthesis...
if you have a function that gives the results, it also works.

[Norie]

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[kevinadrideo]

Please find an example.
I hope that it will help you.

[kevinadrideo]

does anyone can help me?

[martindwilson]

there is no code in that workbook for SetSuperScript()

[kevinadrideo]

Please find the code.
But I want a solution without code. As the example in the Excel file

--------------------------------------------------------
Function SetSuperScript(x As Integer) As Variant
Select Case x
Case 0
SetSuperScript = ChrW(8304)
Case 1
SetSuperScript = ChrW(185)
Case 2
SetSuperScript = ChrW(178)
Case 3
SetSuperScript = ChrW(179)
Case 4
SetSuperScript = ChrW(8308)
Case 5
SetSuperScript = ChrW(8309)
Case 6
SetSuperScript = ChrW(8310)
Case 7
SetSuperScript = ChrW(8311)
Case 8
SetSuperScript = ChrW(8312)
Case 9
SetSuperScript = ChrW(8313)

End Select
End Function
---------------------------------------------------


thank's

[kevinadrideo]

Thank you, I find the solution.

Best regards
Kevin

[Norie]

Kevin

Could you share the solution with us?

I'm kind of curious about it, and that's kind of like the whole point of forums like this, helping people by sharing knowledge.