extract links from sheet?

[falfuly]

Hello,

I have an excel sheet that contains 300 entries .
Each entry is a name ‎of a website (that links to the website).

In order to create a Google Custom ‎Search Engine, I need to copy only the links and paste them into the ‎configuration panel of the search engine.

The problem is that when I copy the ‎entries, I can only paste the captions of the links, not the links themselves. ‎

Any solutions?

Thanks a lot! Eyal. ‎

 

[pavin]

Try using this function:

Paste the code in a new module in the VBA editor and use the function GetAddress() refering to the cell. Hope this helps

Function GetAddress(HyperlinkCell As Range)
    GetAddress = Replace _
    (HyperlinkCell.Hyperlinks(1).Address, "mailto:", "")
End Function