|
Forgot to mention a couple things--
first, after putting in your list of addresses, I would suggest that you copy and Paste Special the output section (under the blue headers) to another sheet and then sort them (this will essentially remove all the blank lines and will get rid of the formulas). To Paste Special, you need to highlight and copy (in the normal way) the output section, then go to a new sheet (or somewhere else on the same sheet), right click --> Paste Special... --> Values --> OK. Pasting in the normal way will actually paste the formulas as well, which is not what you want. Sorting this new sheet will force all the blanks to the top or bottom of the list (depending on whether you choose Ascending or Descending order). If you're doing the addresses 1000 at a time or whatever, you can then paste your next group below the first and so on. You can wait to sort til the end, of course.
-- the other thing, you can significantly reduce the memory burden and thus do more addresses at once by deleting all the columns to the right of the city/state/zip column; these are only there in the case that you have one or more addresses that have many lines. So if your addresses only end up taking columns F:J, you can delete columns K:N; you can always fill them back in later from left to right (columns F:N) all have essentially the same formulas.
|