How to Split Apart Addresses in Excel (Other)

You've just found a new list of leads with the addresses in a single column, and you want to split them up so you can use one or more of its components as filters. 

1. The first thing that you need to do is to select the column where the address info is. Here are two ways to do it.

Mouse and Keyboard: Click the letter above the column where the address info is, and it'll select the entire column.

Keyboard Shortcut: Select any cell from the column that has the address info. Then press and hold Ctrl, and hit Space.Step 1 Multiple Columns 

2. Once selected, go to the Data tab.

Mouse and Keyboard: Go into the ribbon at the top of the screen and select Data, and then choose Text to Columns.

Keyboard Shortcut: Press and hold Alt, and then press A. Let go of Alt, then press E twice.Step 2 Multiple columns 

3. This will bring up the Convert Text to Columns Wizard. On the first page, make sure you select Delimited and then press Next.Step 2 multiple columns 

4. If the addresses in your file are separated by commas such as '1 Union Street, San Francisco, CA 94111', you should select Comma as the Delimiter and then press Next.step 3 multiple columns 

5. This next page will show you what your list of addresses will look like. You can press Finish to see the result of your split out addresses.Step multiple columns 

6. The final step is naming the headers such as 'Address, City, State, Zip Code' as you have multiple columns where before you just had one.Step 6 multiple columns

NOTE: Once you've split the column, you will need to choose Multiple Columns when you upload it in the app. Also, remember to create new columns for the filters that you need. For example, you have the "State" column that will be used for geolocating your account on the map. Create a duplicate, and label it as "Filter by State" just to differentiate them according to how they will be used in the app.

Drive 20% Less. Sell 20% More.

Watch a Demo Video

See Badger Maps in Action

Get a Live Demo

Chat with our sales team & get a custom demo

Try Badger with your Team

See how your sales team can sell more

Support & Legal
Support Status Privacy Policy HIPAA Compliance Terms of Use Data Processing Addendum Contact Us Manage Cookies