<div>
Hi<br />
<br />
Is this what you are looking for?<br />
<a href="https://www.experts-exchange.com/questions/28626967/Get-url-from-hyperlink-column-cells.html" rel="ugc">Get url from hyperlink column cells</a>
</div>


Hi

Is this what you are looking for?
Get url from hyperlink column cells [https://www.experts-exchange.com/questions/28626967/Get-url-from-hyperlink-column-cells.html]

<div>
no<br />
<br />
cell value<br />
asdjknajk blah blah &nbsp;<a href="http://example.com" rel="ugc">http://example.com</a> afakj blah blah<br />
<br />
output<br />
<a href="http://example.com" rel="ugc">http://example.com</a>
</div>


no

cell value
asdjknajk blah blah  http://example.com [http://example.com] afakj blah blah

output
http://example.com [http://example.com]

Get-url-from-cell.xlsx

<div>
will the url always begin with http and end with .com?
</div>


will the url always begin with http and end with .com?

<div>
Me too.<br />
<br />
In <a href="https://www.experts-exchange.com/M_258447.html" rel="ugc">my profile</a> you'll find links to some articles I've written that may interest you.<br />
Marty - MVP 2009 to 2014
</div>


Me too.

In my profile [https://www.experts-exchange.com/M_258447.html] you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014

<div>
<div class="content wysiwyg-content">
i have text in cells<br />
<br />
in those text is a url <br />
<br />
<a href="http://example.com" rel="ugc">http://example.com</a><br />
<br />
i need to extract the url...but its not in the front or the end of the text
</div>
</div>


i have text in cells

in those text is a url 

http://example.com

i need to extract the url...but its not in the front or the end of the text

parsing text from excel text block

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