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?