how to import excel addresses into labels

We can parse the Names and State in Excel later. In this example, we’re going to use a comma to separate these fields. Each record had 3 lines representing: Name, Address, and City, ST, and Zip. The next part is to define our fields which will be placed in Excel columns. So don’t worry that your formatting looks off and various lines look combined. Microsoft Word will show a count of how many replacements it made. Word Find and Replace with paragraph marks ^p Your Find and Replace dialog should look like the one below.

Enter the symbol you wish to use for your record delimiter, such as a tilde in the Replace with: textbox.

Select Paragraph Mark from the pop-up menu.

Your dialog will now show more Search Options.

Click the More > button at the bottom.

From the Editing group, select Replace.For example, if your list also included email addresses, you wouldn’t want to use the sign as your field delimiter. Be careful not to use a character that appears on your list. ⚐ I like to use the tilde ~ sign, but you can use any uncommon character. We’ll substitute a unique character as a record delimiter. Notice how a paragraph mark exists at the end of each record.Turn on Paragraph marks ¶ using Ctrl + Shift + * or click the Paragraph button on the Home menu.This is the item Excel will look for to separate each contact. The first step in this process is to add a record delimiter. It really depends on how comfortable you are with Word and Excel. In these cases, the records were uniform, with each contact consisting of three lines with a blank line in between.Īnother approach you could take is to convert the list to a Word table and then copy it to Excel. Thus, the address record looked like the records below.īefore starting, review your address list and look for common denominators and possible exceptions. Also, they wanted to split the data into distinct columns. However, they wanted one row for each contact record. For various reasons, they needed to get the data into Microsoft Excel. I suspect they were some address directory or contact list. The main difference is the user interface.Įach user started with a list of names and addresses in Microsoft Word. The steps are very similar in older versions of Microsoft Word and Microsoft Excel. For this tutorial, I’m using Microsoft 365.

How to import excel addresses into labels