Different formatting in a cell with a concatenated formula?

  • Thread starter Thread starter andy2812
  • Start date Start date
A

andy2812

Yes, if a1 = blue, and b1 = red, and the formula in cell c1 is =a1&b1,
want the result to look like this: bluere
 
Formulas don't support this character by character formatting. If you can
convert the results of the formula to values, you can do it though--but that
destroys the formula.
 
You must log in or register to reply here.

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

Formula with Cell reference to include formating? 13
keep source formatting when concatenating 1
copy and paste the cell with formula ="1" 3
Concantenate which keeps bold of some parts. 5
Format of cell 1
Subtraction of 2 numbers/cells 3
Format of cell 1
Concatenate Help 5

Back
Top