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.