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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CONCATENATE text to create a formula to be evaluated 2
Can conditional formatting be used where ..... 2
Index Match Concatenate 8
conditional formating adjacent rows 4
Challenging formatting formula 12
Concatenate with carriage return- how to remove blanks? 3
Problem organizing text data into new excel page 3
Timesheet formula problem 2

Back
Top