How to Split Apart Addresses in Excel (Other)

  1. Home
  2. Knowledge Base
  3. Troubleshooting
  4. Excel Issues
  5. How to Split Apart Addresses in Excel (Other)
  1. Home
  2. Knowledge Base
  3. Initial Setup
  4. Import
  5. 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

Related Articles