I have 2000 cells with friendly text that says "email" with an embedded
hyperlink that is for example "
Cells currently displays the friendly text "email" in blue and underlined.
I want to format cells to display the underlying hypertext (jump text) vice
the friendly text.

There's no format for this, if it is a hyperlink from inserthyperlink you
can edit it and remove any friendly name, if it is from the hyperlink
function you can use

")

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Brook" wrote in message
...
I have 2000 cells with friendly text that says "email" with an embedded
hyperlink that is for example "
Cells currently displays the friendly text "email" in blue and underlined.
I want to format cells to display the underlying hypertext (jump text)
vice
the friendly text.

Hi "Brook",

assuming you are saying cell D4 displays Rob Jones and
the link is

You can use a user defined function (UDF) to see that

E4: =personal.xls!HyperlinkAddress(D4) -- if UDF is installed in your personal.xls
or
E4: =HyperlinkAddress(D4) -- if UDF is installed in same workbook

see http://www.mvps.org/dmcritchie/excel...perlinkaddress

For directions to install a macro or a user defined function see:
http://www.mvps.org/dmcritchie/excel....htm#havemacro

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Brook" wrote in message ...
I have 2000 cells with friendly text that says "email" with an embedded
hyperlink that is for example "
Cells currently displays the friendly text "email" in blue and underlined.
I want to format cells to display the underlying hypertext (jump text) vice
the friendly text.