Horst

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

Activate the Web Toolbar from ViewToolbars.

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

On Tue, 27 Sep 2005 21:33:28 +0200, horst wrote:

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