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


G

Guest

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

Advertisements

P

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]","(e-mail address removed)")

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon
 
Ad

Advertisements

D

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

--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top