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.
- 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.
- 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’.
- This will bring up the ‘Convert Text to Columns Wizard’. On the first page, make sure you select ‘Delimited’ and then press ‘Next’.
- 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’.
- 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.
- 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.