Display hyperlink as web address

  • Thread starter Thread starter tatih
  • Start date Start date
T

tatih

Hi,

I have a list of several hundreds of hyperlinks. Not all the hyperlink
are displayed as the web address, e.g. instead of www.db.com the tex
that is displayed in the cell would be rather Deutsche Bank => the nam
of the company or subsidiary. I can make the text to display = we
address through edit hyperlinks. However, I will have to manually do i
for every single cell. Is there a way to automate this?

Thanks a lot
 
I am not at all clear what you currently have and what you want.

If I am to read that you have a column of text representing links (www.db.com)
where would you pick up the text (Deutsche Bank) that you want to display.

I'm not sure of what you have and what you are asking for.
You can probably find the answer though on my web page
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

Do you know about the HYPERLINK Worksheet Function

If you have column of hyperlinks such as pasted from a webpage,
or pasted from favorites (bookmarks) then you could use
hyperlinkaddress to extract the hyperlink to another column.
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#hyperlinkaddress
 
If you are using Excel 2000 or later:

Save your workbook before running the below (works on the activesheet).

Sub FixHyperlink()
Dim hlink As Hyperlink
For Each hlink In ActiveSheet.Hyperlinks
hlink.TextToDisplay = hlink.Address
Next
End Sub

If this doesn't do what you want, close the workbook without saving after
running it.
 
Back
Top