Insert this character please?

[clout90265]

Does anyone know how to insert this character in Excel?

Unicode Character 'SUPERSCRIPT LEFT PARENTHESIS' (U+207D)

I'm trying to enclose a char(185) with superscripted left and right parenthesis.


Thank you!

 

[chicagocomputerclasses]

Have you tried character 40 and 41 ?

 

[clout90265]

Have you tried character 40 and 41 ?

Those characters are not superscripted. Char 185 is.

 

[Gary McMaster]

Maybe this:

Range("A1") = ChrW(8317) & Chr(185) & ChrW(8318)

 

[SpillerBD]

Maybe this:

Range("A1") = ChrW(8317) & Chr(185) & ChrW(8318)

Love MSFT's details on that function ChrW and AscW....

 

[Gary McMaster]

XL2013 only (I believe) It can be done with the following formula:

=UNICHAR(8317)&CHAR(185)&UNICHAR(8318)

 

[clout90265]

Maybe this:

Range("A1") = ChrW(8317) & Chr(185) & ChrW(8318)

Gary--

Perfect. Wish I had Excel 2013, but have 2010. So I ran the macro and then just copied the output into my formula.

Thanks so much.