How do I create a hard or soft return in my calculation?

 

I have two different fields in one calculation but I want them spaced out with a sharp return.

 

ex: data1field1 ¶ data1field2

 

¶ does not work as easily as I expected. The message says "An  Operator (e.g +,-,*,...) is expected here."

put the pilchrow in quotes i.e data1field1 & "¶" & data1field2 or use List ( data1field1 ; data1field2 )

Been a long time since version 7, but if I recall, it requires quotes sounding  the Pilcrow “¶".

ex: data1field1 ¶ data1field2

 

¶ does not work as easily as I expected. The message says "An  Operator (e.g +,-,*,...) is expected here."

 

 

It needs to be:

data1field1 & ¶ & data1field2

The & concatenate operator is the one that's expected.

 

 

 

put the pilchrow in quotes i.e "¶"

 

A single ¶ does NOT need to be quoted.

Or instead, use the Ampersand as it should be. DUH