Email addresses won't hyperlink in Excel

[Bodye]

I am working on a spreadsheet which has contact information in it, one of
these fields being email addresses.

Most of the hyperlinks work fine and open into the mail client when clicked,
but there are two probelms.

1. Some text was copied into this spreadsheet, over old email addresses.
When the new email address is clicked, the mail client opens and shows the
old email address. Any ideas how to clear the field properly?

2. Some of the email addresses won't hyperlink. I have tried right clicking,
but the option isn't available. When copied into Word, they work fine.

Thanks
Bodye

 

[Daniel.C]

1. You have to modify the hyperlink : right click on the hyperlink and
click on "edit hyperlink"; then change the mail address zone.
2. Can you post a sample file on www.filedropper.com or another such
site ?
HTH
Daniel