Rich Text Formatting within a Concatenate

[ddebruinav]

Is this possible? Excel 2007. I have concatenated the words from three cells together into one. No problem there. What I would like to do is to add headings in the concatenated cell that are bolded without bolding the text.

===================================
Cell 1
text value = "this is the current state"

Cell 2
text value = "this is the future state"

Cell 3
text value = "these are the risks"
==================================
Current Concatenated cell

Current State
this is the current state

Future State
this is the future state

Risks
these are the risks

==================================

Desired Concatenated cell, can you do?

Current State
this is the current state

Future State
this is the future state

Risks
these are the risks
===================================

The headings are bolded, the text is not.

Any thoughts, anyone?

 

[VoG]

Sorry, a formula cannot format a cell.