How do you do hard returns in 1 cell? entering address in 1 cell

J

Jenn

Excel does not seem to have a feature for entering hard returns in a cell.
An example is when you are entering an address. How do you get that
information into one cell?
 
T

Toppers

If I understand your requirement, do Alt+Enter at end of each address line.

Given that I don't know your application, I would advise having address
lines as entries in separate columns rather than in one cell.
 

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

Excel does not accept text format! 0
Split cells next to 1 cell 1
Merging from an Excel file with graphics 1
Search cell value in same column 3
Place picture in Excel cell 0
cell.address gives strange result 1
Word macro that can call cells out of Excel for a find and replace 0
Seeking the character code for entering a Hard Return in a cell? 2

Top