Excel doesn't support that kind of formatting with formulas. If you convert it
to a value, then you can do the formatting, though.

wrote:

Thanks for that, it has solved my problem. How do I get the superscript
to translate through to the cell also?

EG

A1=10oC
A2=+/- 1oC
A3=A1&A2

A3 Displays 100C+/-10C but I want to keep the superscript for the "o"

Thanks,

Slash.

--

Dave Peterson