Forum Discussion
how to validate that email address format is correct or not in xls
Actually, I want to validate the below-given email address format in xls. if the format is correct which means yes then I have to update the value with respect to the email id as true else fals...
Just in case, another notation for your formula could be
=ISNUMBER(FIND(".",D2))*
ISNUMBER(FIND(".",D2, FIND("@",D2)))*
NOT(ISNUMBER(FIND(" ",D2)))*
NOT(ISNUMBER(FIND(",",D2)))
SergeiBaklan Thank you. I tried your formula with 3k emails and it gives the same results as mine, difference is that my formula outputs "TRUE" or "FALSE" while yours outputs "1" or "0". And yours is shorter, its nice to have an alternative.