Hi Lizzy,
Adding to Andrew's reply.

Use Alt+Enter
which inserts a CHAR(10) for a new line, and turns on cell wrap in format,cells,alignment

within a concatenation
=A1 & CHAR(10) & B1
and you must turn on cell wrap yourself in Format, cells, alignment

within a concatenation in VBA
newstring = Oldstring & CHR(10) & Morestring

Failure to turn cell wrap will result in viewing a square printer's bullet, which
is an indication of a character not in the character set you are using..


--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Lizzy" wrote in message ...
I am trying to use excel to create a table full of text. I would like to be
able to format the text within the cell (e.g. entering carriage returns to
put some text on a separate line). I can't seem to make this work. Any
suggestions?