Formula or code to change formatting in cell

[rmtimmah]

Hi,

I have a formula to concatenate multiple cells to one cell. What I would like to do is have the second part of the text in Italics and on a new line. Formula at the moment is:

=CONCATENATE(IF(Question1!C$2="Yes",Question1!B$2 & " ",""),IF(Question1!C$3="Yes",Question1!B$3 & " ",""))

So I would like to see the result look like this in one cell:

Text1
Text2

 

[Jonmo1]

Well, we can do the part about putting the 2nd text on a new line.
But you cannot format a portion of the formula's result in italics...Sorry.

=CONCATENATE(IF(Question1!C$2="Yes",Question1!B$2 & " ",""),CHAR(10),IF(Question1!C$3="Yes",Question1!B$3 & " ",""))
You will have to go to Format - Cells - Alignment and check "Wrap Text"

 

[rmtimmah]

Well that'll work. Thanks for that.