mailto hyperlink sorting

Giganews Newsgroups
Subject: mailto hyperlink sorting
Posted by:  Betty (betty_ellio…
Date: Sat, 11 Oct 2003

I have created "mailto:" links in my worksheet but when I
sort by different columns, the hyperlink seems to stay
with the cell - not with the text it should be attached
to. Even though the text sorts correctly, when I go
to "edit > hyperlink" the link is incorrect.  How do I
permanently attach the link to the text so that my links
are correct no matter how I sort?