my cells with email addresses ling me to the wrong ones
 

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.

my cells with email addresses ling me to the wrong ones
 

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

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

BillT wrote:

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.

--

Dave Peterson