How do I sort e-mail addresses without losing the links?

[Guest]

I have e-mail addresses with links to their addresses in a spreadsheet. When
I re-sort the sheet, all the addresses move but the links stay as an absolute
and don't move with the sort. What can I do to allow the link to move with
the address?

 

[Dave Peterson]

Maybe you can dump the Insert|Hyperlink and replace them with the =hyperlink()
worksheet function (in an adjacent column).

If you have
(e-mail address removed)
in A1

Then you could use:
=hyperlink("mailto:"&a1,"Click me")
or
=hyperlink("mailto:"&a1,a1)
(and hide column A if you want)

 

[Guest]

Dave,
Thanks for the recommendation, but when I tried it, I could not fill down.
I have 18 different e-mail address, but they cover over 800 locaitons. I
can't really type each address individually. Is their anyway to use the edit
fill down?

ds

 

[Dave Peterson]

Maybe you can explain why fill down didn't work?

Just a guess--did you have the data filtered?

 

[Guest]

I was able to do the fill down, but the adddresses still didn't move when I
re-sorted. I'll try your way again. I must have done something wrong.
ds