I am using the following formula to generate a replica of the trendline
information for a scatter plot:

="y = " & TEXT(intercept,"##0.0##x") & IF(slope0," +"," ") &
TEXT(slope,"##0.0##") & CHAR(10) & "R2 = " & TEXT(rsquared,"##0.0##"),

where intercept, slope & rsquared are calculated separately.

Is there a way to superscript the "2" in the R2 part? I cannot format as I
usually would (ctr-1 does nothing). Is there a CHAR equivalent of
superscripting? If so, what is the CHAR equivalent of undoing the
superscript afterwards?

wazooli

nevermind - saw th epost by bernard regarding char(178). works great.

"Wazooli" wrote:

I am using the following formula to generate a replica of the trendline
information for a scatter plot:

="y = " & TEXT(intercept,"##0.0##x") & IF(slope0," +"," ") &
TEXT(slope,"##0.0##") & CHAR(10) & "R2 = " & TEXT(rsquared,"##0.0##"),

where intercept, slope & rsquared are calculated separately.

Is there a way to superscript the "2" in the R2 part? I cannot format as I
usually would (ctr-1 does nothing). Is there a CHAR equivalent of
superscripting? If so, what is the CHAR equivalent of undoing the
superscript afterwards?

wazooli