How can I insert a carriage return and line feed into a cell ?

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

Guest

I am trying to display a statistic with its t_stat in the same cell, one over
the other.
 
Try pressing Alt+Enter
or
Format the cell to wrap from Format|Cells

tj
 
In a concatenation you can use
="line one" & char(10) & "line two" & char(10) & "line three"

You will have to turn on cell wrap for such cells
Format, cells, aligment, cell wrap
Failure to turn on cell wrap will show the square printer's bullets
associated with unprintable characters.

If you are just typing text then use At+Enter for the new line
and Excel will turn on cell wrap for you.

In VBA you would use CHR(10) or vbLF
 
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

Carriage return within a cell 3
Carriage return displays as a small box 8
Excel - carriage returns and formating of text within a cell 2
Separating carriage return data into separate cells 2
Getting rid of carriage return in cell 4
Unicode text and carriage returns 4
Replacing carriage returns with a comma 4
Cut and Paste Text with CRLF into Single Cell 1

Back
Top