Extract link to actual

Hi,

I need some help with something, Not sure if this can be done with a macro/VBA/Add-ins or some other way.

what I want is to extract the link (which is a shortcut ... column B) to be decoded into the next cell with the actual link.

For now I do this manually. Is there a way in which this could be done with anything in the back-end?

I want to do something link what is done in http://www.xposition.co.uk/bitly-decoder.asp

Attached is the excel... Please help me with this...

Thanks,
Tejas