convert hyperlink to email address

[Seemore]

Seemore,

Glad I could help,

Conan








Actually, I think I'm cool now.  I had unmerged the file but option 2
was working only sometimes.  Option 1 on the other hand, I was doing
it wrong.  I didn't quite understand your instructions but after I
reread it, it works perfectly.  Option 1 is perfect and that is the
one I'll use.  Again, I appreciate all your help.- Hide quoted text -

- Show quoted text -

How's about one more? In addition to sorting for duplicates, is there
another code I can use that will search for all non-email addresses?
Basically something that can search for the "@" sign and return a
message when a cell doesn't have that sign.

 

[Conan Kelly]

Seemore,

In a blank column, enter this formula in the first row of you email
addresses list (in this example, the list starts in A7):

=IF(ISERR(FIND("@",A7)),"Not an email address","")

Now copy/fill that formula down. Anything that is not an email addres will
have "Not an email address" in this column.

HTH,

Conan




On Feb 6, 12:13 pm, "Conan Kelly"

 

[Seemore]

Seemore,

In a blank column, enter this formula in the first row of you email
addresses list (in this example, the list starts in A7):

=IF(ISERR(FIND("@",A7)),"Not an email address","")

Now copy/fill that formula down.  Anything that is not an email addres will
have "Not an email address" in this column.

HTH,

Conan


On Feb 6, 12:13 pm, "Conan Kelly"




- Show quoted text -

The stuff you come back with is amazing and works perfectly. You are
saving so many headaches and time. Thanks again.

 

[Conan Kelly]

Seemore,

Any time. Glad to help.

Conan

Seemore,

In a blank column, enter this formula in the first row of you email
addresses list (in this example, the list starts in A7):

=IF(ISERR(FIND("@",A7)),"Not an email address","")

Now copy/fill that formula down. Anything that is not an email addres will
have "Not an email address" in this column.

HTH,

Conan


On Feb 6, 12:13 pm, "Conan Kelly"




- Show quoted text -

The stuff you come back with is amazing and works perfectly. You are
saving so many headaches and time. Thanks again.

 

[Sheri Contino]

Not sure if you will see this ever, but just in case - I just tried this
and both methods worked flawlessly! Thanks -you just saved me a couple
hours of work!