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...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top