Google Answers Logo
View Question
Q: How do I unmask a link in Excel 2002? ( Answered,   2 Comments )
Subject: How do I unmask a link in Excel 2002?
Category: Computers > Software
Asked by: mundo-ga
List Price: $5.00
Posted: 16 Oct 2006 09:13 PDT
Expires: 15 Nov 2006 08:13 PST
Question ID: 774051
I Have a column in Excel 2002 with Masked links i.e. the text that
shows is something like website1, website2 etc with an underlying url
for each one. I want to display the underlying hyperlink in another

I could do this by editing the hyperlink then copying and pasting the
info but I'm looking for a function or Macro that can do this
Subject: Re: How do I unmask a link in Excel 2002?
Answered By: tar_heel_v-ga on 20 Oct 2006 08:35 PDT

Thanks for your question.  To achieve the results you are looking for,
add this user defined function to a module in your VBA project:

Public Function HyperlinkURL(ByRef Cell As Range) As String

   HyperlinkURL = Cell.Hyperlinks.Item(1).Address

End Function

Assuming column A has your list, place the following in column B


Then copy it all the way down the column.

Thanks again for your question.  If you need any additional
clarification, please let me know.



Search Strategy:
show link excel

Show Hyperlink in separate Column
Subject: Re: How do I unmask a link in Excel 2002?
From: rainbow-ga on 16 Oct 2006 10:13 PDT
This may be helpful:

Best regards,
Subject: Re: How do I unmask a link in Excel 2002?
From: mundo-ga on 16 Oct 2006 12:49 PDT
Thanks Rainbow, I think this might be kind of on the right track but I
still need some more help as my problem is slightly different.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy