char(10) does not work to form a new line in my formula

S

Sandy

i am merging a few cells into one, but want them to appear on 3 separate
lines. char(10) does not seem to be working.
 
T

T. Valko

You have to format the cell to wrap text.

A1:A3 = merged cells

Entered this formula:

="Line1"&CHAR(10)&"Line2"&CHAR(10)&"Line3"

Goto the menu Format>Cells>Alignment tab>Wrap Text>OK

The result of the formula appears as:

Line1
Line2
Line3

You may have to adjust the row height to get the exact fit you want.
 
Top