Nanogirl21
Active Member
- Joined
- Nov 19, 2013
- Messages
- 330
- Office Version
- 365
- Platform
- Windows
I have about 3,000 shorten URLS. They was converted using Goo.Gl by someone else. Is there a way in Excel that I can unshorten these URLS and populate the full link in a new cell? Cell A2, A3, A4 ect is where I would like to put the new full URL. There is a website (Unshorten any URL - unshort.me) that allows you to unshorten URLS. It’s a pain to go through 3,000 URLS and copying them over to and from the website manually. Is there a way to do this in excel? Macro maybe?
Here are two URL's for example.
<colgroup><col></colgroup><tbody>
</tbody>
Thank you.
Here are two URL's for example.
http://goo.gl/QIp7xJ |
http://goo.gl/Hga4Dw |
<colgroup><col></colgroup><tbody>
</tbody>
Thank you.