Mailing Lists: How to Split the Address Column in Excel

Mailing lists how to split the address column in excel.

After you purchase a mailing list, you can edit the Excel file as much or as little as you like. Some people like to add additional columns for ‘Notes’, or combine their new list with a current customer list, and every so often, some people need to sort their list by Street Address. In order to do this, you need to know how to separate the ‘Street Address’ into 2 new columns, 1) Street Number, and 2) Street Address.

Step 1

Open your Excel file mailing list.

Mailing lists how to split the address column in excel
Mailing lists how to split the address column in excel

In a LeadsPlease Consumer Mailing List, the street address will be in Column C.

Highlight Column C, and Insert 2 new columns to the right. Your 2 new, blank columns, will be D and E.

Column D will be used for the ‘Street Number’, and column E will be used for the ‘Address’.

Mailing lists how to split the address column in excel

Step 2

Input the following code into cell D2 : =LEFT(C2,FIND(” “,C2,1))

Mailing lists how to split the address column in excel

Then click ‘enter’, and Excel will insert the street number into cell D:

Mailing lists how to split the address column in excel

Step 3

Click inside cell E2, and enter the following formula:    =TRIM(RIGHT(C2,(LEN(C2)-LEN(D2)+1)))

Mailing lists how to split the address column in excel

Then click ‘enter’, and Excel will insert the street address into cell E2.

Mailing lists how to split the address column in excel

Now, just copy and past the 2 formulas into the other cells in column D & E. Done!

Need help? Call us +1 866 306 8674

Mailing List Edits How To Change The Case Text In Excel

Mailing List edits how to change the case text in excel.

LEADSPLEASE  mailing lists are available for instant download in Excel (CSV file format).

You will need to be able to format your lists in ways that make sense for your marketing plans for example: If you are an insurance agent mailing to people who are aging into medicare it will make sense to sort your list by birth month. This allows you to mail out in batches for each month easily according to your budget and also to keep a careful track of your responses.

Sometimes customers also need to know how to change the case text for mail merge.

Excel is very user friendly and can be sorted in a variety of ways but if you need to know how to edit the case text in Excel the Microsoft support website is the place to go!

LeadsPlease can help you format your list for printed labels and can help you sort your list by for example zip code, state, birth month and so on.

Get your mailing list formatted for printing your own labels.

4 Quick Tips to Designing a Successful Direct Mail Flyer

4 quick tips to designing a successful direct mail flyer.

Explosion Dance Studio recently came to LeadsPlease in search of a targeted marketing mailing list for their direct mail campaign. The goal of their mailing, was to send a flyer to Families with Children over 3 yrs old, who live in a 2.5 mile radius of their dance studio; Families who would be most interested in having their children attend dance classes. Explosion Dance Studio kindly shared their mailing piece with us, and wow, is it a good one! It has all the key ingredients for a successful mailing :

  • Dramatic, eye-popping photos
  • Easy-to-read message
  • Clear Call-to-Action
  • Bold offer – $10 off + Free T-Shirt

This is a mailing piece that would definitely catch your eye and demand attention and response!

Well done Explosion Dance Studio!

4 Tips To Designing A Successful Direct Mail Campaign
4 Quick tips To Designing A Successful Direct Mail Campaign