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

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?

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

Press Alt+ENTER to break for a new line within a cell
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jenn" wrote:
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?

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

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.

"Jenn" wrote:

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?