Getting hyperlinks

  • Thread starter Thread starter horst
  • Start date Start date
H

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
 
Copy the hyperlink to your new cell,
right-click the copy > Hyperlink > Remove Hyperlink.

The cell should now display ordinary text.

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
 
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
 
Back
Top