How to Enter valid Email in a Excel

Описание: Tired of manually checking for email typos in your data? 📧 This quick Excel Data Validation trick forces every entry in your column to be a valid email address! Learn the exact formula I use to guarantee data integrity in under 60 seconds! ⚡️
The Value Key points & formulaow to Validate Emails in Excel:
Go to Data tab Data Validation.
Select Custom.
Paste this formula to check for the symbol and a period
The Custom Formula:
=AND(ISNUMBER(FIND("@",A1)),ISNUMBER(FIND(".",A1)),ISERROR(FIND(" ",A1)))