How to add superscript to a label

[paul_ripley]

Hello

I'd like to have a column header as below but I don't know how to make the '1' as supercipt.

The label as the moment is just  Value movement £m

Can you help please

Many thanks

Paul

[Frank_Hartmann · Accepted solution]

=' Value movement'&chr(185)&' £m'

[paul_ripley]

Brilliant, many thanks

[paul_ripley]

..do you also know how you do this for a 2 and a 3?

[sudeepkm]

chr(178) for 2 and chr(179) for 3

[paul_ripley]

thanks a lot

[Frank_Hartmann]

if you want to know all possible chr() then create a straight table:

Dimension:

=Valueloop(1,10000)

Expression:

=Chr(RowNo())