Data Validation

Hi Duncan

Thanks for getting in touch. Validating email addresses is harder than you think as there are many combinations.

Here's a suggestion that looks for a "." and "@". To apply this, select your range, click Data > Data Validation and choose Custom. In the formula enter:

=AND( FIND(".",A1),FIND("@",A1))

Assuming the data starts in A1 - modify as required. Give it a try and let me know how you get on.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector