Microsoft KB Archive/74458

{| = SAVE.LABELS.AS Example Creates Labels with No Spaces in Q+E =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q74458

SUMMARY
The example on page 109 of the &quot;Q+E for Microsoft Excel's User's Guide&quot; for version 3.0 shows the SAVE.LABELS.AS function with the field names concatenated. When using this example, the output label will concatenate the fields without a space between the first and last names and between the state and zip code fields.

MORE INFORMATION
The example on page 108-109 shows:

SAVE.LABELS.AS('ADDR.LAB','FIRST_NAME+LAST_NAME;CITY+,  +STATE+ZIP',5,1,0,0,0) The first name and the last name fields, as well as the state and zip code fields are joined so that the output label concatenates these fields without a space between them. A correct example should read:

SAVE.LABELS.AS('ADDR.LAB','FIRST_NAME+ +LAST_NAME;CITY+,  +STATE+ +ZIP',5,1,0,0,0) The quotation marks between the fields are single quotation marks (two set on each side of the space) and will add a space between the joined fields.