Wrapping text in a cell

A

Andrew Chalk

In a single cell, suppose I want text to appear on two lines. Viz:



Case One

Case Two



How do I do that so that I specify the wrap point?



Thanks!
 
J

JohnGoogle

If you are typing the data into the cell use Alt-Enter between each
string to indicate where you want a line break to occur.

Case One<Alt-Enter>Case Two
 
J

JohnGoogle

If you are setting the contents of the cell via a formula or VBA code
make sure that you have changed the formatting for the cell also. Check
that the <right mouse click> Format Cells / Alignment Tab / Wrap Text
check box is selected.

For example, I created a formula for a cell:

="1st line"&CHAR(10)&"2nd line"

This appeared as "1st line2nd line" on a single line in the cell
initially. Once I changed the cell formatting (as above), the cell
appeared as two lines with the 'split' as required.
 
Top