Quote:
Originally Posted by Richard PS  Would each line of the address need to be in a different cell in Excel? |
My experience with inputting addresses via the "import data wizard" is that it's best to put each element of the address into different cells. I normally use the column headings
address1
address2
city
county
postcode
although address2 and county are often left blank which doesn't affect the process. It's definitely useful to have postcodes separate because, given the geographical precision of UK postcodes, misplaced street addresses can be picked up when they're too distant from the postcode.
Anyway with only around 1000-1100 addresses to locate I don't think you'll have any problems with spotting rogue locations! What you will probably have to do is automate the calculation of drive times, which can readily be done with a liitle bit of vba for excel.
Rgds