Validation to ensure correct email is input on a Spreadsheet

[Chris Waller]

Afternoon All,

I am trying to create validation to ensure the email addresses I am copying to an Excel Spreadsheet is in the format of the following "FirstName.SecondName@aaaaaaaaaaa.aaaaaaa.aaa.aaa.aa". The email from the @symbol to the right of the email are all identical with only the names being different. I have tried several combinations, but none have quite hit the mark. The "a's" in the above are substitute for alphabetical characters. TIA

Apologies, I posted this, this morning but used the wrong title.

 

[Fluff]

Duplicate to: Conditional Formatting To Check Validity of Email Address

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.