super-scripting text when concatenating text

[mandukes]

How to insert superscript in concatenating text as given below.

="ΣH= ½ WH2 = ½ x 1x " & E171 & "2 = "

output :

Regards,
~M

 

[RoryA]

You can't format part of the formula result with superscript. However, there a character for a superscript 2 which you can get by holding the Alt key and typing 0178 on the number keypad.

 

[Norie]

You could use UNICHAR(178) for superscript 2.

="ΣH= ½ WH2 = ½ x 1x " & E171 & UNICHAR(178) & " = "

 

[RoryA]

If you have 2013 or later.