Life Feed character

G

Guest

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.
 
G

Guest

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
 
G

Gord Dibben

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
 
B

Biff

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><ENTER>Donald Duck

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to combine multiple records into one record in a Query 0
Trying to combine multiple records into one record in a Query 1
Trying to Siplify a Query in MS Access 2003 1
Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without g 7
Access 2003: Carriage return and line feed in text field 6
how to insert CRLF (carrage return/line feed) in report 8
Trouble with chr(13) & chr(10) in IIF statement 3
adding a Carriage Return or Line Feed character to an update query 2

Top