I work for a railway contractor. Every time they ask me to go to a different station. I have all the postcodes of the stations. Now I wanted to create a URL (for Excel sheet) which tells me the distance of my workplace from my house.

So, here's my solution.

1. Create a variable in Excel having my postcode in it. I gave it the name of home_location. I put '+' sign where there was a space (to match the hypertext coding for URL).
2. Then write the following formula in Excel.

=HYPERLINK("https://www.google.com/maps/dir/" & home_location & "/" & Ref of Destination post code , Ref of the name)

for any additional stop, add &"/"&Ref of Next stop before the ','.