Getting hyperlinks

[horst]

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

 

[George Gee]

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

The cell should now display ordinary text.

George Gee

 

[horst]

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

 

[George Gee]

I'm sorry horst, but I really cannot understand what it is you require!

What does this hyperlink point to?
A website, an email address, a place in an Excel workbook?

Please try to give us some information, so that we may try to
help you!

In the meantime, try this:
Type the text you require, in the cell you require.
Right-click the cell, point to Hyperlink, and click and see if there is
anything there that may be what you are looking for.
Especially "Text to display", at the top.

Or:
Right-click your existing hyperlink, point to Hyperlink, and click,
Have a look at "Text to display", at the top.


George Gee

 

[Anne Troy]

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

 

[horst]

Thank you Anne, this is exactly what I was looking for!
Horst

 

[Gord Dibben]

Horst

If you just have a few of these you could do it manually.

Activate the Web Toolbar from View>Toolbars.

Click on the hyperlink in the cell to follow it.

Copy the address/path from the Web address dialog.

Paste it into Excel.


Gord Dibben Excel MVP

 

[Anne Troy]

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