FORMAT DIFFERENT PARTS OF CONCATENATE CELL? 1

[cjsmithmeegan]

I AM LINKING SEVERAL DIFFERENT CELLS AND SPACES USING CONCATENATE FORMULA. THE FORMATTING OF EACH INDIVIDUAL CELL DOESN'T FLOW THROUGH. IS THERE A WAY TO FORCE THIS? OR TO FORMAT PART OF THE CONCATENATE FORMULA AS BOLD, PART AS ITALICS, PART AS A COLOR? CJ

 

[TonyJollans]

Hi cjsmithmeegan,

Sorry, but (AFAIK) this can not be done without code.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.