QL-500A
FAQs & Troubleshooting |
When I use the Excel Add-In with my address data, the address is not displayed in the correct format. Each Excel column is printed on a separate line.
The Excel add-in is designed for simple printing of information without any complicated formatting. Therefore, if you need to place the data of two or more columns on the same line, another method needs to be used to achieve this.
There are two ways to print your addresses correctly from Excel:
Each Excel column is printed as a separate line on your label. So if we take this example of an address stored in Excel:
When the text is highlighted (A2 to F2), the P-touch Add-In icon is clicked, the text on the label will be placed as follows:
You need to combine the text in the Excel columns into the correct order.
There are two ways to achieve this – by combining the text in Excel and using the Excel Add-In to print, or by combining the text in P-touch Editor before printing directly from the editor program.
To combine the text in Excel, we use the "CONCATENATE" function. Using our example Excel data again:
we need to combine the first three columns into one line. To do this, we would use the following Excel command in cell G2:
=CONCATENATE(A2," ",B2," ",C2)
Because cell A2 contains "Mr", cell B2 contains "John" and cell C2 contains "Smith", the concatenate command as shown above will produce:
Mr [SPACE] John [SPACE] Smith (the space is created by placing a space between two quotation marks - " ").
So, by moving our cursor to cell reference G2, and using this function we get:
Repeat this in the other columns (H2, I2, J2 etc), or if we do not need to join the columns together, simply use the command to copy what is in the other cell (for example, use the command "=D2").
Now that our data is in the correct order, we can are able to highlight these new cells, and then click on the P-touch Add-In icon to make the address label appear correctly:
To repeat the same procedure on all the other rows of data, simply highlight the new cells we have created (in this example, G2 to I2), and copy/paste them in the other rows:
Whenever using the P-touch Add-In for Excel, highlight the data in the new columns we have created (columns G, H and I), and the label will print correctly.
By loading your Excel sheet with your addresses, you can join the data in certain fields (columns) so they appear next to each other on your label.
This example shows how to join the multiple fields together and print your labels.
Of course, with this function you can join any fields (columns) together to make your data appear in the correct order.
If the file being used contains multiple sheets, the Select Table dialog box appears. Select the sheet that you wish to link to the layout.
Entering "\n" enables you to create a new line.
For details on selecting a record range, refer to the following table.
Printing Range | Data of Printing Subject |
---|---|
All Records | Designates all records. |
Current Record | Designate the currently displayed record. |
Selected Record(s) | Designates the record currently selected in the database window. |
Record Range | Designates the record range designated in "From" and "To". |