<:#288,4560><+!><:f240,BHelveticaNeue MediumCond,0,0,0><-!><+!>Common Usage<:f240,6Times New Roman,0,0,0>
@Normal@<:#2592,4560><+!><-!><:f240,6New Caledonia,0,0,0>Use the combine function when creating mailing labels. You can automatically combine the FNAME and LNAME fields into one field, as well as the CITY, STATE and ZIP fields into one field. This can make label design easier
, since only the two calculated fields need appear on the label, instead of the five fields: FNAME, LNAME,CITY, STATE and ZIP.
@Normal@<:#864,4560><+!><-!><:f240,6New Caledonia,0,0,0>Combine the contents of the FNAME field and LNAME field into one field with one space separating the first and last names.
@Normal@<:#1440,4560><:f240,6New Caledonia,0,0,0>First names are entered in a field called FNAME. Last names are entered in a field called LNAME. Create a new calculated field called
<+">fullname, <-">for example,<+"> <-">and enter the following into the formula box:
@Normal@<:#2304,4560><:f240,6New Caledonia,0,0,0>FNAME is the name of the field which holds the first names and LNAME is the name of the field which holds the last names. The separating space is added by typing a single quote ('), pressing the space bar to enter the space and
then typing another single quote ('). Separate each item of the combine statement, these are called arguments, with a comma.
@Normal@<:#288,4560><:f240,6New Caledonia,0,0,0>
@Normal@<:#288,4560><:f240,6New Caledonia,0,0,0>Result of the Combine formula:
@Normal@<:#864,4560><+#><-#><:f240,6New Caledonia,0,0,0>Combine the contents of the CITY, STATE, and ZIP fields into one field with a comma between the city and the state.
@Normal@<:#3744,4560><:f240,6New Caledonia,0,0,0>Where CITY, STATE and ZIP are the names of the fields which contain the city, state and zip information. Note that the comma which is to appear between the city and state names is entered by typing a single quote ('), the comma,
a space and a closing single quote. The space between the state and zip is entered by typing a single quote ('), pressing the space bar to enter the space and a closing single quote ('). Each item of the combine formulathe CITY field, the comma and space
, the STATE field, the space, and the ZIP field are separated with commas.
@Normal@<:#288,4560><:f240,6New Caledonia,0,0,0>
@Normal@<:#288,4560><:f240,6New Caledonia,0,0,0>Result of the Combine formula:
@Normal@<:R1,11,1,1080,1,2160,2,3240,1,3600,1,4320,1,5040,1,5760,1,6480,1,7200,1,7920,1,8640,><:#220,4560><+!><:f180,6New Caledonia,0,0,0>CITY STATE ZIP <+">csz <-">
@Normal@<:R1,11,1,1080,1,2160,1,3150,1,3600,1,4320,1,5040,1,5760,1,6480,1,7200,1,7920,1,8640,><:#440,4560><+!><-!><:f180,6New Caledonia,0,0,0>Cupertino CA 94014 Cupertino, CA 94014
@Normal@<:R1,12,1,1080,1,1710,1,2160,1,3150,1,3600,1,4320,1,5040,1,5760,1,6480,1,7200,1,7920,1,8640,><:#440,4560><:f180,6New Caledonia,0,0,0>New York NY 10002 New York, NY 10002 <:f200,6New Caledonia,0,0,0> <:f240,6New Caledonia,0,0,0>