How to Split Apart Addresses in Excel (Other)

You've just found a new list of leads and want  to see them on the map. Unfortunately, that list has the address in a single column and you're not sure how to fix it.

Splitting out addresses from a single column is actually not that complicated.

  1. If you're a fan of keyboard shortcuts, select the a cell that has the column that has the addresses in it and then press and hold [ctrl] and then press [Space]. It will select the whole column. If you're more of a mouse and keyboard type, clicking the letter above the column will select the whole column.Step 1 Multiple Columns
  2. Press and hold [Alt] and then press A. Let go of [Alt], then press [E] twice. With the mouse, you can go into the ribbon at the top of the screen and select 'Data' and then 'Text to Columns'.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

See Badger in Action

Check out our full walkthroughs

Request a Demo

See what Badger can do for your team

Badger Maps

539 Broadway

San Francisco, CA 94133, USA

415-592-5909
Support & Legal
Support/Knowledgebase Status Privacy Policy Terms of use Contact Us