Print Tips for DuraLabel Printers
Printing Instructions:
How to merge data from two different columns into one cell in Excel
This guide will walk you through how to format a data set like the list on the left and make it look like the list on the right in a few easy steps.
 |
» » » » » » » |  |
To insert a line break into a cell
1. In cell C1 create an equation. For this example: enter A1 and press keys "Alt+Enter" and then enter B1. When "Alt+Enter" is used, it will insert a line break.
Your cell should then look like:
To format the alignment to your preference
2. After your data is entered in cell C1, it is recommended to center both horizontally and vertically.
Note: Make sure Wrap Text is checked. This will make the place holder for the line break disappear and make your data appear on two lines on one cell.
To turn this into a sequence so cell C2 would be =A2&B2
3. Click on the little box in the bottom right of cell C1 and drag it down to the last row of the data set.
Note: If you are printing from excel, 96 pixels = one inch.
