my cells with email addresses ling me to the wrong ones

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

After I data sorted the spreadsheet the email and web site cell's take me to
the wrong addresses. Its like the link stayed with the cell instaed of the
address.
 
Another reason to use the =hyperlink() worksheet function.

With the email addresses in column A:
=hyperlink("mailto:"&a1,"Click Me")
 
You must log in or register to reply here.

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

Similar Threads

AOL email scam 2
#N/A In Cells 7
Excel Typed text appears in wrong cell 0
Lookup returning wrong results 0
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),QuoteNotes, 2
Using Macro how to create email link for the email addresses in aRange or Selection 8
how can i convert an email address to a web address 3
Compare lists when one column contains multiple entries 3

Back
Top