Thread: How do I get a line break when using a formula to combine cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TESA0_4
 
Posts: n/a
Default How do I get a line break when using a formula to combine cells
I want to combine names and addresses into single cells, but I want a line
break so that the name is on one line and the address on the next line within
a cell. When manually entering data to a cell ALT,ENTER gives line break. I
want the formula to give the same effect as ALT,ENTER.
I'm using Excel2003.
Thanks if you can help!!
Reply With QuoteReply With Quote