Adding a new line to the results of a formula
You can format the results of a formula by inserting carriage returns in your calculation.
To add a new line to the results of a formula:
1.
With the database open, choose File menu > Manage > Database.
2.
In the Manage Database dialog box, click the Fields tab.
3.
If your database contains more than one table, select the appropriate table from the Table list.
4.
In the Fields tab of the Manage Database dialog box, select the calculation field, then click Options.
5.
In the Specify Calculation dialog box, click to insert the cursor in the place you want the line to break.
6.
Click the ¶ button (carriage return operator) to insert a line break.
See Defining calculation fields for information about the dialog box.
7.
Click OK.
Note  Type \¶ (backslash followed by a carriage return operator) to enter a carriage return (paragraph) symbol instead of an actual line break.
Examples
Field1 & ¶ & Field2 returns:
Fred
Jane
when Field1 contains Fred and Field2 contains Jane.
 
"Fred ¶ Jane" returns:
Fred
Jane
Related topics 
About formulas
About functions
Functions reference (category list)
Functions reference (alphabetical list)
Text operators
Using operators in formulas
Was this topic helpful? Send feedback.