Superscript text formatting in function

[Ark68]

What do I need to do to use the concatenate function to take two cells of data:

A1 = 42
B1 = 13.56

to get this result 42O13.56 ... where O is superscripted to indicate degrees?
I have the basics ...

=concatenate(A1,"O",B1)

, but how would I format the "O" to be superscript?

 

[MickG]

Try:-

=CONCATENATE(A1,CHAR(186),B1)

 

[Ark68]

Awesome! Thx

 

[cjcobra]

just an FYI, it's much easier to use "&" instead of CONCATENATE.

=A1 & CHAR(186) & B1