Invalid Email Id

download and activate more func add in from
http://download.cnet.com/Morefunc/30...-10423159.html
then try
with list in col a
=REGEX.COMP(a1,"^([0-9a-zA-Z]+[-._+&])*[0-9a-zA-Z]+@([-0-9a-zA-Z]+[.])+[a-zA-Z]{2,6}$",1)
you could probably use the regular expression
"^([0-9a-zA-Z]+[-._+&])*[0-9a-zA-Z]+@([-0-9a-zA-Z]+[.])+[a-zA-Z]{2,6}$"
in place of the one given in the vba code given in your other post at mrexcel
this will unfortunately give
bojalasrikanth@live.como
as valid beacause there are a few about like .mobi and .name which are valid

Or similarly,

Please Login or Register  to view this content.