my cells with email addresses ling me to the wrong ones

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

[Dave Peterson]

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