How do I display hyperlink as embedded jump text vice friendly tex
 

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.

How do I display hyperlink as embedded jump text vice friendly tex
 

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.

How do I display hyperlink as embedded jump text vice friendly tex
 

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.