Concatenate different text formats

  • Thread starter Thread starter Keith R
  • Start date Start date
K

Keith R

I have a worksheet with the following formula:

If(A7>25,A3,("Not Available [" & A3 & "] " & A21))

A7 is numeric (integer)
A3 is numeric (formatted as a percent)
A21 is superscript text

Is there any way to carry over cell formatting, so that I might get the
result:

Not Available [37%] ^5 high^

(where ^5 high^ represents superscript text)

Any advice appreciated!
Keith R
 
Hi Keith
no way to carry over cell formats with formulas. Functions can only
return values but not formats
 
Back
Top