Different formatting in a cell with a concatenated formula?

A

andy2812

I have a concatenated formula that pulls text from 2 different cells.
The 2 cells are formatted differently (i.e. 1 cell has blue text an
the other cell has red text and a different font) and I want to kee
these formats. However, the cell with the concatenated formula take
the format of that cell. Is there anyway to do this
 
X

xlsxlsxlsxls

You men to have the concatenated cell part blue and part red? Don'
think you can do this. Or if you just wanted to format it like ONE o
the cells I'm sure you know how to copy/paste special/format
 

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

undo concatenated cells 2
undo concatenated cells 1
Formatting a cell with a concatenated formula 1
concatenate & conditional formatting in one 1
combine cells with different formats 4
Maintain Formatting with Formulas 1
Excel Conditional Formatting 1
Conditional formatting in a formula 1

Top