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

G

Guest

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

Guest

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

Window resets to A1 when entering data 5
How do I stop email addresses from changing color, size? 3
Cell Format Issue 7
Conditional locking of a cell 2
Enter value, convert, read result from same cell 1
How do I copy the content of multiple cell in excel 1
Cell Format 1
after entering a text in one cell, next cell should disp the entd 1

Top