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.
 

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

Line Feed in Formula Adds Double Quotes? 3
Concatenation frustrations.... 7
Excel Create a New line in a Word Link without double "" around result 0
CHAR(10) does not create new line in excel 2007 4
CHAR(10) 5
How to reference Cells AA and forward with CHAR (and a bonus quest 2
Add A Line In A Text Cell 2
Concatenating a range of cells from another sheet, possible? 7

Top