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
column.

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
automatically.

Mundo..

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

=HyperlinkURL(A1)

Then copy it all the way down the column.

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

Regards,

-THV

Search Strategy:
show link excel

Reference:
Show Hyperlink in separate Column 
http://www.experts-exchange.com/Applications/MS_Office/Excel/Q_21193528.html

This may be helpful:

http://www.experts-exchange.com/Applications/MS_Office/Excel/Q_20746390.html

Best regards,
Rainbow

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.