Line breaking in Excel (2013) via formula

Asked

Viewed 11,636 times

1

How to break line in formula in Excel 2013 (above)?

I used to do it this way:

="linha1"&CARACT(13)&CARACT(10)&"linha2"

Current result:

linha1linha2

Expected result:

linha1
linha2

Theoretically only the CARACT(10) already represents a vbNewLine, but I always had to use the CARACT(13) together to work.

However, in the most current version of Excel, I am not able to visualize the line break.

Could someone help?

excel line-breaks
  • 3

    In the corresponding cell formula right-click mouse goes on option Format Cells flap Alignment and in the Text control tick the box Wrap text. Thus the command CARACT(10) will work.

  • Excellent! Thank you!

2 answers

0

I don’t know if you can still help someone, but without the use of formula, it is possible to use the ALT + Enter to insert line breaks.

I hope it helps.

0

If you make a 

=concatenar(A1;"
";A2)

or 

=A1&"
"&A2

Write command with line break between "", you will have the expected result. To break the line in the formula just use Alt+Enter.

Browser other questions tagged excel line-breaks

You are not signed in. Login or sign up in order to post.