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 "mailto:123@ABCDEFG.COM"
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 insert>hyperlink you
can edit it and remove any friendly name, if it is from the hyperlink
function you can use

=HYPERLINK("mailto:123@abcdg.com","123@abcdg.com")

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Brook" <Brook@discussions.microsoft.com> wrote in message
news:3BDD5479-021B-4457-9A27-912EB555455C@microsoft.com...
>I have 2000 cells with friendly text that says "email" with an embedded
> hyperlink that is for example "mailto:123@ABCDEFG.COM"
> 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 mailto:123@ABDEFG.com

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" <Brook@discussions.microsoft.com> wrote in message news:3BDD5479-021B-4457-9A27-912EB555455C@microsoft.com...
> I have 2000 cells with friendly text that says "email" with an embedded
> hyperlink that is for example "mailto:123@ABCDEFG.COM"
> 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.