I know this should be easy but having trouble locating an answer.

Creating a label layout with

FirstName-LastName on line 1

and (if data exists) Spouse's first & last names on line2.

Address on line3.

To avoid unwanted carriage returns & spaces, I tried using a single merge field for names that has a calculation that looks like below. For some reason the output is creating a blank line where the spouse's name would be, when no spouse first/last name data exists.

Here's the calculation.

First Name & " " & Last Name & "¶" & Second First Name & " " & Second Last Name

FilemakerPro9/Mac OSX 10.6

[email protected]

Learn about and use the list() function.

List(

trim( First Name & " " & Last Name) ;

trim(Second First Name & " " & Second Last Name);

Address;

City & " " & State & " " & Zip

)