How can I enter carriage returns into text within a cell in excel

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?

You need to use Alt-Enter to add line breaks within a cell.


Lizzy wrote:
> 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?

Press Alt+Enter within a cell to enter carriage return

"Lizzy" wrote:

> 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?

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" <Lizzy@discussions.microsoft.com> wrote in message news:B98E5A2A-7EA5-4183-A6A8-D0BA894C9C7A@microsoft.com...
> 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?