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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you embed a new line in a formula similar to &" "& but with a new line
instead
 
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.
 
You must log in or register to reply here.

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
Auto Fill formula when inserting a new line 4
hOW DO i COPY FORMULAS FROM ONE SPREADSHEET TO ANOTHER IN EXCEL 1

Back
Top