Combining two text cells with an Alt+Enter

etres · Mar 11th, 2002, 04:56 PM

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. · Mar 11th, 2002, 05:00 PM

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 · May 29th, 2002, 11:44 AM

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

Mark O'Brien · May 29th, 2002, 11:55 AM

=A1& CHAR(10) &B1

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

HTH

redgreenfan · May 29th, 2002, 11:59 AM

Thank you....

I was missing the additional "&" symbol.

This board is great!

May 29th, 2002, 11:55 AM	#4
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	=A1& CHAR(10) &B1 Make sure the cell is set to "Wrap Text". HTH __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 11th, 2002, 04:56 PM	#1
etres New Member Join Date: Mar 2002 Posts: 4	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

Mar 11th, 2002, 05:00 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	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.

May 29th, 2002, 11:44 AM	#3
redgreenfan New Member Join Date: May 2002 Posts: 6	How do you insert the "alt+enter" into the formula to get a hard return in the cell?

May 29th, 2002, 11:59 AM	#5
redgreenfan New Member Join Date: May 2002 Posts: 6	Thank you.... I was missing the additional "&" symbol. This board is great!