Cool beans. :)
************
Anne Troy
www.OfficeArticles.com

"horst" wrote in message
...
Thank you Anne, this is exactly what I was looking for!
Horst

On 27.09.2005 22:00, Anne Troy wrote:

Try this, Horst:
http://vbaexpress.com/kb/getarticle.php?kb_id=227
************
Anne Troy
www.OfficeArticles.com

"horst" wrote in message
...

Thank you, but I want to get the hyperlink and not the text!
Horst

On 27.09.2005 20:31, George Gee wrote:


Copy the hyperlink to your new cell,
right-click the copy Hyperlink Remove Hyperlink.

The cell should now display ordinary text.

George Gee


horst wrote:


Hi,
I have in a cell (Excel 2002) a text with a hyperlink.
How can I get in another cell this hyperlink (as simple text)?
Thanks
Horst