Formula to calculate distance between to post codes in Excel

[Shazz]

Hi All,

Can anyone help me at all, I have aspread sheet and i want to directly calculate the distance between to post codes, with out having to calculate it manually by going to google maps, is there a way of doing this at all.

Any help is appreciated.

Shazz
xx

[Kyle123]

Have a look in the Tips and Tutorials, I've posted 2 examples

[Shazz]

Hiya,

Where can i find Tips & tutorials, I have looked but can not seem to find it.

Could you post a direct link here fro me.

Shazz
xx

[Kyle123]

http://www.excelforum.com/tips-and-tutorials/

[Shazz]

Thanks for that, I have had a look at the tip here http://www.excelforum.com/tips-and-t...times-pt2.html but it does not explain where put the code and what you actually need to do, I am fairly new to excel so i need step by step instructions

Shazz

[Kyle123]

Try the other one, it's more explicit. It's a bit further down the page

[lesleyhollett]

Hi, I have the same question. New to this forum. Can you send me the link to the step by step tip? thanks