line break in a cell
 

An expert suggested this formula to me "=TEXT(E31,"mmm-yyyy") & CHAR(13) &
E42", which puts a square as the line break symbol. Is there a way to get the
line break instead of a symbol? Thanks.

First, you need to use CHAR(10) not CHAR(13). Then, go to the
Format menu, choose Cells, then the Alignment tab. There, check
the "Wrap text" setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"luvgreen" wrote in message
...
An expert suggested this formula to me "=TEXT(E31,"mmm-yyyy") &
CHAR(13) &
E42", which puts a square as the line break symbol. Is there a
way to get the
line break instead of a symbol? Thanks.

Thanks Chip. It worked. I have another question, when the text show as x-axis
lable, it is still in one line not two lines when it is not horizontal. Is
there a way to make the label show as two lines?

Thanks.

"Chip Pearson" wrote:

First, you need to use CHAR(10) not CHAR(13). Then, go to the
Format menu, choose Cells, then the Alignment tab. There, check
the "Wrap text" setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"luvgreen" wrote in message
...
An expert suggested this formula to me "=TEXT(E31,"mmm-yyyy") &
CHAR(13) &
E42", which puts a square as the line break symbol. Is there a
way to get the
line break instead of a symbol? Thanks.