Display-Link.xlsm

<div>
Just what I needed. &nbsp;Thanks.
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
Is there a formula or other method in Excel which will extract a URL out of a hyperlink?<br />
<br />
For example, suppose you have a spreadsheet in which A1:A5 contains the following links:<br />
&nbsp;<br />
<a href="http://www.wimp.com/dognightmare/" rel="ugc">Poor doggy has a nightmare.</a><br />
<a href="http://www.wimp.com/bigface/" rel="ugc">Funny big face.</a><br />
<a href="http://www.wimp.com/dogtrick/" rel="ugc">Dog performs two-legged trick.</a><br />
<a href="http://www.wimp.com/pigssound/" rel="ugc">Piglets react to sound.</a><br />
<a href="http://www.wimp.com/brushingteeth/" rel="ugc">Just some girl brushing her teeth.</a><br />
<br />
Is there anything you can put in B1:B5 to display the respective URLs?<br />
<br />
Thanks
</div>
</div>


Hello,

Is there a formula or other method in Excel which will extract a URL out of a hyperlink?

For example, suppose you have a spreadsheet in which A1:A5 contains the following links:
 
Poor doggy has a nightmare. (http://www.wimp.com/dognightmare/)
Funny big face. (http://www.wimp.com/bigface/)
Dog performs two-legged trick. (http://www.wimp.com/dogtrick/)
Piglets react to sound. (http://www.wimp.com/pigssound/)
Just some girl brushing her teeth. (http://www.wimp.com/brushingteeth/)

Is there anything you can put in B1:B5 to display the respective URLs?

Thanks

Extract a URL out of a hyperlink in Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.