How do you embed a new line in a formula similar to &" "& but

  • Thread starter Thread starter Guest
  • Start date Start date
P,

="Line 1" & CHAR(10) & "Line 2"

Have Wrap Text turned on (Format - Cells - Alignment) or you'll get a little
square character for the newline.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed AND formula in SUMIF formula 1
Starting a new line 2
Data Subtotals (similar but not exactly the same data) 2
how to embed print instruction portrait landscape in excel 2
How do I embed SharePoint document properties in Excel 2007? 3
Is it possible to embed a PDF in an Excel document comment field 1
How do you embed a picture into an excel document 1
Embed PDF and select file name and path 2

Back
Top