zip code

  1. M

    Sorting A large list into smaller lists on different sheets

    Hello Everyone, I currently get a list of addresses from a lead generation company daily. I want to be able to take that list and segment it into smaller lists by zip codes that are in each of my companies territories. This way I can make Mail Merge documents from the smaller lists so they...
  2. M

    Format ZIP Code for Multiple Countries

    In Sheet1 I have the following table of zip code formats: <tbody> ISO Country Format AU Australia 9999 AT Austria 9999 BE Belgium 9999 BR Brazil 99999[-999] CA Canada A9A 9A9 DK Denmark 9999 FI Finland 99999 FR France 99999 DE Germany 99999 HU Hungary 9999 IE Ireland A9A...
  3. K

    PLEASE SHOW ME HOW TO Separate full address INTO COLUMS ADDRESS, CITY, STATE, ZIP

    I NEED :help:TO SEPARATE FULL ADDRESS IN DIFFERENT COLUMS OR COMMAS: Example: THE WAY I HAVE THE DATA IS LIKE THIS: <tbody> <tbody> THIS IS THE WAY HAVE THE LARGE DATA ADDRESS CITY STATE ZIP 9737 NW 41 ST SUITE 182 DORAL, FL 33178 <tbody> 19737 Carabana st. Fort Myers, FL 33901...
  4. N

    VBA throwing runtime error with new data in table

    Hello Everyone. This is my first time posting, but I hope someone can help because I am going batty. I have attempted to use VBA to get Zip +4 zip codes from usps website. Everything was going fine with sample data, but when I copied new data into the table, I start getting a runtime 5 error...
  5. W

    Does latitude and longitude fall within area?

    Hello, first time poster. I have a list of zip codes and their corresponding latitude and longitude points from the US census bureau. I was hoping this data could be used to determine if a given zip code fell within a certain radius of another zip code. In other words, if I could take the...
  6. V

    Zip Code to Zip Code Driving Distance formula

    I have been looking for and experimenting for 2 weeks trying to put together a set zip code to Customer Zip code formula but I continue to to get a straight line distance and I need a driving distance. I saw reference to using bing maps database to do this. Totally Stuck ..... anyone ever...
  7. 2

    Zip Code Range Extraction

    I have been trying to figure out how to extract zipcode range from a single cell. My data contains a single column with multiple formats. One cell could have a single zipcode like 30040. But, another could have a range like 30040-99. Sample data below. Would like to have just individual zipcodes...
  8. C

    Matching and Merging Data from two+ columns

    Hi, I have a spreadsheet with a zip code column to which I want to append city and state information from a second spreadsheet that I have that contains 40,000+ rows of zip, city and state information. So I think I that I somehow need to match the zip codes from the two sheets and then merge...
  9. T

    VBA to call MapPoint Shaded Area Map for ZIP Code

    I have a set of data, 2 columns containing ZIP Code in the 1st column and counts in the 2nd, and wish to call a MapPoint map to show shaded areas for each ZIP code with a full spectrum map. I am having difficulty finding the proper syntax to create the shaded area map with the appropriate data...
  10. S

    Zip Codes and Leading Zeros

    I have an address database and when I save it as a .csv file the leading zeros in the zip code column disappear. I know that I can format it as text, but when I resave it and reopen it, because its .csv it loses the format. I think I need to change the column from integer to character, but I...

Some videos you may like

This Week's Hot Topics

Top