Find Special character in email ID

[prashantJ_2003]

hi
please tell me a formula to find a special characters in email id. which shows a invalid emails.
Thanks
Prashant

 

[Chihiro]

This would be rather difficult doing it in formula. If you are comfortable with VBA. You can use Regular Expression to check if email address is valid or not.

 

[Asheesh]

Hi,

It can be done using a formula...but what do you consider an invalid email address..can you please share some examples...with the expected result..

Also, check the below link..if it can assist you writing the formula..

http://chandoo.org/forum/threads/ne...ls-with-special-characters.24607/#post-148172

 

[Chihiro]

Hi Asheesh,

Ah my bad. I read the original post as checking for valid email. I had similar project few years back and remember pulling my hair out doing it in Excel Formula. Ended up using Regular Expression that has about 98% accuracy to write custom function.

Some interesting read:
http://ex-parrot.com/~pdw/Mail-RFC822-Address.html
http://www.regular-expressions.info/email.html

 

[Asheesh]

Oh I c...nevermind..