Life Feed character
 

I'd like to fill a single cell so that it looks like this:

Daisy Duck
Donald Duck
Huey
Dewey

How do I enter the carriage return (line feed)?
I tried the following and various other versions which don't work:

+"Daisy Duck"&Chr(10)&"Donald Duck" ... etc.

Life Feed character
 

To enter a line feed when entering in a cell,
Hold down the [alt] key and press [enter]

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"ArthurJ" wrote:

I'd like to fill a single cell so that it looks like this:

Daisy Duck
Donald Duck
Huey
Dewey

How do I enter the carriage return (line feed)?
I tried the following and various other versions which don't work:

+"Daisy Duck"&Chr(10)&"Donald Duck" ... etc.

Life Feed character
 

Manually use ALT + ENTER after Daisy Duck and again after Donald Duck etc.

Finish Dewey with a regular ENTER.

With a formula.....

="Daisy Duck" & CHAR(10) & "Donald Duck" etc.


Gord Dibben MS Excel MVP

On Sun, 22 Oct 2006 14:38:01 -0700, ArthurJ
wrote:

I'd like to fill a single cell so that it looks like this:

Daisy Duck
Donald Duck
Huey
Dewey

How do I enter the carriage return (line feed)?
I tried the following and various other versions which don't work:

+"Daisy Duck"&Chr(10)&"Donald Duck" ... etc.

Life Feed character
 

Try this as a formula:

="Daisy Duck"&CHAR(10)&"Donald Duck"

Format the cell to wrap text.

Or, just type it in:

Daisy Duck<ALT<ENTERDonald Duck

Biff

"ArthurJ" wrote in message
...
I'd like to fill a single cell so that it looks like this:

Daisy Duck
Donald Duck
Huey
Dewey

How do I enter the carriage return (line feed)?
I tried the following and various other versions which don't work:

+"Daisy Duck"&Chr(10)&"Donald Duck" ... etc.