Distance between Zip Code

[Welsh Mark3]

Is anyone aware of an Excel function that could calculate the distance between two zip codes? Column A contains ZIP 1, and Column B ZIP 2.

I believe I had a formula to do this previously but cannot find it, any help is greatly appreciated.

 

[Joe4]

You may want to try a Google Search. I have that question asked a handful of times here and elsewhere.
Here are a few links to similar questions on this site:

Calculate Distance between Zip Codes

Dear Smartest Exclers In The World, I have a table with row headers as source zip code and column headers as destination zip codes and I would like to calculate the distance between the two zip codes. Does anyone know how to do that, maybe a User Defined function or something?

www.mrexcel.com

Excel Formula or Macros - Distance Between Two Postal Codes

Hi, I'm from Canada & I'm trying to see if there is a formula or macros I can use to calculate the distance (KM) between two postal codes. A1 - Postal Code 1 B1 - Postal Code 1 C1 - Distance (KM) Any help would be greatly appreciated. Thanks, Laurinda

www.mrexcel.com

Distance between ZIP codes - Google Maps

I searched the site and found some posts regarding the use of Google Maps through Excel, but none of them are quite what I need to do. Can anyone help? I have a list of zip codes in Column A and Column B of my worksheet. I need to plug each of these zip codes into google maps to calculate the...

www.mrexcel.com