View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jon Shelton Jon Shelton is offline
external usenet poster
 
Posts: 1
Default How do I use a formula to create a new line of text in a cell?

I'm trying to concatenate address components (Address Line 1, Address Line 2,
City, State, and Zip Code) from their individual cells into a single cell
that is formatted correctly in 2 or 3 lines of text. In my formula, I'm
trying to find a way to output Address Line 1, start a new line, put Address
Line 2 on the new line, start a new line, and put the City, State, and Zip on
the last line.