Formatting a cell with a concatenated formula

A

andy2812

Sorry for the double post but I'm not sure which is the best forum fo
this question so I've posted it in 2 different ones.

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
 

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

Different formatting in a cell with a concatenated formula? 1
copy parts of different cells into new cell 3
Help with conditional formatting 3
Conditional Formatting 4
Is Auto Expansion (i.e., wrap text) of a cell possible when thecell's contents are based on another 2
Formula not working - vlookup 1
Format part of text in concatenated field 4
Concatenating Currency and Percent 5

Top