Finding Distance between 2 UK postcodes in Excel

[sk211]

Hi,

Im trying to find the distance between 2 uk postcodes on a file in excel using google maps- I have seen different threads around this, but none of the examples seem to be working for me. Would anyone have a formula to use? The 2 postcodes are in separate columns and I want the distance in miles in a third column if that possible. Thanks

 

[Kerryx]

Calculate travel time and distance between two addresses using Excel + Maps API

 

[sk211]

Calculate travel time and distance between two addresses using Excel + Maps API

Thank you!