Hi!

I have a big list of email id's placed on column A, but I need to check all email id's are legitimate or not
I am looking for an Email ID validation formula that can be applied to the next column (B).

Validations:
1. May contain all English characters, numbers, - (hyphen), _ (underscore), . (periods)
2. Must contain one @ symbol, at least one . (period) after @
3. Must not contain any non-english characters other than : -, _ or .



Thank you in advance