Dear Sirs,

 

I try to convert Excel data sheet to Calc. I found the following
problem.

 

Break line is possible add to text by CTRL+ENTER. Can I add Break Line
character to a formula?

 

For example (new line character is shown by NL)

 

The following example is correct

 "First line NL second line"

 

The following example is not correct

="First line" & IF(L2;"NL Second line";"")

 

Can you help to me how to add New Line character to a formula?

 

Best regards

Pavel Babocky

 

Reply via email to