How to extract the link address from a hyperlink

[Gavona]

The scenario I am in is that I am using a pivot table to summarise an excel table. One of the columns in the table contains hyperlinks. Unfortunately these use "friendly names" whereas I need to bring across the actual link i.e. "

http://webint03/pplusweb/aspx/perfo...&id=bbk&type=view&BBKId=767&................"

My plan had been to bring across the address in the pivot, to hide that column and then use the Hyperlink function to one side of the actual pivot table. This worked ok when friendly names were not used.

Is there a way I can extract the link address in the original table? I suppose I could use code if i need to but would prefer a solution that doesn't phase others as much.

Any suggestions gratefully received!

Thanks in advance,

Gavin

 

[Gavona]

Ok I will go with a code solution

Function LinkAddress(Target As Range)
LinkAddress = Target.Hyperlinks(1).Address
End Function

Gavin