how to print address labels from excel 2013

The template for the labels will be created in Word, but the data used to populate the labels will be drawn directly from the Excel spreadsheet. The easiest way to accomplish this is to create the labels using Microsoft Word’s “Mail Merge” function.

Most people who are printing labels from Excel are trying to create address or product labels, with each row in the spreadsheet needing to be transferred onto one label. We’ve had a few enquiries asking for the simplest way to set up labels using text from an Excel spreadsheet. Please note that if you are using MAC you will have to enter CHAR(13) instead of CHAR(10).Or copy the link! Templates: from Excel to Word in a Mail Merge Your address label is now formatted with the correct line breaks!

Click the OK button to save your settings.

Under the Text control heading check the Wrap Text checkbox.

Right click on the highlighted area and select Format Cells….

Highlight the entire Address Label column.

What the majority of the forums failed to mention is that CHAR(10) will only work if Text Wrap is enabled for that field. My formula now looked similar to the following:Īs you can see, there were no changes to my address label cell. So, I added CHAR(10) to my formula where I needed a line break. Upon searching for a solution I found several forums that indicated that I should use CHAR(10) to program a soft return. This combined all of the columns, however the fields were placed all on one line. The formula looked similar to the following: I used Excel’s built in CONCATENATE() function. In order to save time, I wanted to use Excel functions to concatenate all of the columns into one field, which sounds easy enough.

I had an Excel file that had 200 people with their name, address, city, state, and zip-code all in different columns. I was presented with a problem when I was attempted to print address labels.

How to print address labels from excel 2013