how to validate many email in microsoft excel

Question

I have many email in excel file, but i have problem, many email must be validate, because missing @, . , and in the email there is a space or quote, and others, i want in my right cell i can add false or true for right email, so i can filter or sort for fix that or you can gift me options to use others software

thanks before sorry if my english language is bad

for example :

test@mail.com true
test @mail.com false
test@mail false
test.mail false
test@mail.com' false

Use a Regex: http://www.msofficegurus.com/post/How-to-VBA-email-validation.aspx — Julien Marrec, Jul 15 '13 at 15:08

score 1 · Accepted Answer · answered Jul 15 '13 at 16:00

1

=AND(ISERROR(MATCH("?*@?*.?*";A1;0))=FALSE;ISERROR(FIND(" ";A1))) will match your examples correctly (for cell A1).

Will validate any string which has no spaces and has 1/+ characters, then "@", then 1/+ characters, then ".", then 1/+ charaters.

Not perfect, but very lightweight!

answered Jul 15 '13 at 16:00

LS_ᴅᴇᴠ

10,823
1
23
46

thanks you so helpful, just point 5 can't be validate, but is ok, thank you so much – chaky Jul 30 '13 at 14:57

how to validate many email in microsoft excel

1 Answers1