Combining two text cells with an Alt+Enter

[etres]

Have two text cells. Want both cells combined into one cell. But cell A is in bold and should remain in bold, while cell B is in italics. B should be on separate line.

My current formula in C is =A1 (Alt+Enter for new line)&B1

Hoqwever, I loose the bold type of Cell A

 

[Mark W.]

Font formatting can only be applied to text . =A1&B1 is composed of cell references. Cell references do not inherit the font formatting of their contents.

 

[redgreenfan]

How do you insert the "alt+enter" into the formula to get a hard return in the cell?

 

[Mark O'Brien]

=A1& CHAR(10) &B1

Make sure the cell is set to "Wrap Text".

HTH

 

[redgreenfan]

Thank you....

I was missing the additional "&" symbol.

This board is great!