How do I place 3 lines of text (an address) in 1 cell?

G

Guest

I want to place a 3 line address in one cell. Every time I try to press
"Enter" to go to the next line... it goes to the next cell. Please help.
 
B

Bernard Liengme

Before press down Enter, hold the ALT key down to insert a linefeed
character.
May need to format cell to allow word wrap.
best wishes
 
G

Gord Dibben

Mark

Bernard has shown you how but do you really want to do this?

You can run into problems later when trying to sort by address numbers or street
names.

Also you may someday want to do a mailmerge for labels or such.

You should have each section in a separate cell.


Gord Dibben MS Excel MVP
 

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

Word Removing unwanted "lines" within a MS Word 10 table 1
In Excel how do I force text into next line before first is full? 8
Removing unwanted "lines" within a MS Word 10 table 2
PowerPoint Shuffle (swap) objects on PPT slides with the same name only 0
How to give count of lines before all 5 values pass?? 18
Automatically place text in one cell into cell in another sheet 2
Excel Typed text appears in wrong cell 0
Mulitple text lines in a single cell 2

Top