Line break in Excel (2013) via formula

1

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

I used to do this:

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

Current result:

linha1linha2

Expected result:

linha1
linha2

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

However, in the most current version of Excel, I can not see the line break.

Could someone help?

    
asked by anonymous 10.07.2017 / 17:23

0 answers