How to Convert Mailing Labels to Columns in Excel
Often, people create mailing labels in a Word document using a list made in an Excel worksheet. If you received mailing labels in the form of a Word document and would like to create a spreadsheet from the list, you can convert the labels into columns in Excel. This will enable you to sort, filter and utilize the data from the labels in other applications such as mail merges or guest lists. Using Excel's "Paste Options" feature, choose how you want the data entered in the worksheet.
Other People Are Reading
Instructions
-
-
1
Open the Word document containing the mailing labels. In Word 2003 or earlier, go to the "File" menu, select "Open," click on the document name and click the "Open" button. In Word 2007, click the "Office Button," select "Open," click on the document name and click the "Open" button. In Word 2010, click the "File Tab," select "Open," click on the document name and click the "Open" button.
-
2
Select all of the information in the labels by clicking the "Table Move Handle" at the top left side of the table. This handle looks like crossed, double-headed arrows. Because Word views the label document as a table, clicking this button will highlight and select the entire document. You can also select all of the information on the tables by clicking anywhere in the document and pressing the keyboard shortcut "Ctrl+A."
-
-
3
Copy the selected information by clicking the "Copy" button on the "Standard" toolbar in Excel 2002 or 2003 or in the "Clipboard" group of the "Home" tab in Excel 2007 or 2010. You can also use the keyboard shortcut "Ctrl+C."
-
4
Open the Excel worksheet where you want to convert your mailing labels. Click inside the top cell of the first column into which you want to paste the data. Although you are only clicking inside of one cell, Excel will convert the data into the specific number of columns and rows required, saving you from having to count the number of cells into which you need to paste the data.
-
5
Click the "Paste" button on the "Standard" toolbar in Excel 2002 or 2003 or in the "Clipboard" group of the "Home" tab in Excel 2007 or 2010. You can also use the keyboard shortcut "Ctrl+V."
-
6
Click the "Paste Options" button that appears as a small clipboard at the bottom right side of the pasted data. Select "Keep Source Formatting" if you want the converted information to match the formatting used in the Word labels. Select "Match Destination Formatting" if you want the formatting you are using in your Excel worksheet applied to the data.
-
1
