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 false.Can anyone pls help me with the correct formula or process. caria.matt@zew.de d.gibons@lse.ac.uk weink@ese.eur.nl mark@york.ac.uk joa@gmail.com