+ Reply to Thread
Results 1 to 3 of 3

ZIP to Area Code file

  1. #1
    Registered User
    Join Date
    01-06-2018
    Location
    West Coast USA
    MS-Off Ver
    2013
    Posts
    61

    ZIP to Area Code file

    Anyone know where I can download a spreadsheet of US zip codes and corresponding area codes?

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,430

    Re: ZIP to Area Code file

    You could copy and paste them from here: http://www.heartandcoeur.com/heart_t..._codes_usa.php

    or here: https://www.phaster.com/zip_code.html

    Depends exactly what you are wanting to do with it.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    01-06-2018
    Location
    West Coast USA
    MS-Off Ver
    2013
    Posts
    61

    Re: ZIP to Area Code file

    What I mean is given a zip code, NOT City State, what's the corresponding telephone area code?

    For example, there are 33,099 postal zip codes in the US. I have such a table that provides the city and state corresponding to the zip code. I need to add another column that contains the area code for the given zip code.
    Last edited by GraeagleBill; 03-31-2019 at 03:28 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Setting Print area with VBA code on active sheet - Can't get my code to work
    By hans302 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-14-2017, 05:07 AM
  2. Area code counting
    By Hunlight in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-07-2017, 04:29 AM
  3. Replies: 2
    Last Post: 09-14-2016, 02:51 AM
  4. [SOLVED] Save selected print area as a pdf file using the text from a specific cells as the file na
    By A440 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2015, 04:14 PM
  5. Replies: 0
    Last Post: 01-13-2013, 02:44 PM
  6. Area Code Look up
    By cmahon1995 in forum Excel General
    Replies: 4
    Last Post: 12-05-2012, 09:00 PM
  7. Print Area:What would be the code for setting the print area
    By wammer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-02-2005, 02:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1