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

[Brook]

I have 2000 cells with friendly text that says "email" with an embedded
hyperlink that is for example "mailto:[email protected]"
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.

 

[Peo Sjoblom]

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

=HYPERLINK("mailto:[email protected]","[email protected]")

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

 

[David McRitchie]

Hi "Brook",

assuming you are saying cell D4 displays Rob Jones and
the link is mailto:[email protected]

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/buildtoc.htm#Hyperlinkaddress

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

--