Thread: How to line break in one cell via a formula to stack cell entries
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default How to line break in one cell via a formula to stack cell entr
Right click Format Cells Alignment tab Wrap text OK out

"Dave" wrote:

Hi Pete, I am interested in the solution to this one. I tried A1&CHAR(10)&A2,
but it just returned the contents of A1 and A2 separated by a little box, all
on one line. What am I doing wrong?
Reply With QuoteReply With Quote