Distance between 2 addresses

Hey,

need a formula or SOME way to calculate the distance between two addresses!


column A=name of place (ex: HOME)
columb B=address (1234 n excel st, city, state, zip code)
column C= address (4321 s forum avenue,city,state,zip code)


WANT
COLUMN D= distance between b and c
column E= (if column A = HOME , then column E is some text assigned to that name in column A)



column A column B column C column D column E
steakhouse address 2nd address distance between B and C (if A=home then e=1, if A=steak then 2, etc.. )
home
seafood
home
home
etc.