my cells with email addresses ling me to the wrong ones

B

BillT

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

Dave Peterson

Another reason to use the =hyperlink() worksheet function.

With the email addresses in column A:
=hyperlink("mailto:"&a1,"Click Me")
 
Top