View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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?