Href is not working in my excel sheet

**Saravana Prabhu** · 12-13-2010, 03:46 AM

Actually I've set of records in which one column has values similar to <a href=http://www.google.com> google </a>.

This is not working, column has "<a href=http://www.google.com> google </a>" as it is, but I'm looking for google as value and link to http://www.google.com.

Please help in fixing this..

Advance Thanks..

**teylyn** · 12-13-2010, 04:14 AM

Hello,

with the href in A1, you can use

=HYPERLINK(MID(A1,FIND("http://",A1),FIND(">",A1)-(FIND("http://",A1))))

cheers,

**Saravana Prabhu** · 12-13-2010, 06:39 AM

Hi Teylyn,
Thanks for your reply..
But this is not the answer that I'm looking for.

Again I will try to explain from my example, I need "google" to be displayed in the column that linked to "http://www.google.com".

Hope I've explained.

Thanks a lot for your support,

**teylyn** · 12-13-2010, 07:11 AM

OK,

=HYPERLINK(MID(A1,FIND("http://",A1),FIND(">",A1)-(FIND("http://",A1))),MID(A1,FIND(">",A1)+1,FIND("<",A1,2)-FIND(">",A1)-1))

this will extract the BLUE part of the href as per below as the Friendly text

<a href=http://www.google.com> google </a>
<a href=http://www.MyDomain.com>MyDomain</a>
<a href=http://www.MyDomain.com>Click Here</a>

Note that your href example has a leading and a trailing space encasing the word "google".