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

Enter carriage return in Excel 2010 text string 2
Formula I can't figure out 2
Concatenation frustrations.... 8
Text To Column max 26 characters 7
Line Feed in Formula Adds Double Quotes? 3
Improving Macro That Keeps First Letter 0
Excel does not accept text format! 0
Page numbering with Merged Document and IF statements 1

Top