I am trying to filter out bad data in a spreadsheet full of emails, looks like we got hit with some spammers to one of our sites and flooded our email lists with random junk, what I'd like to do is make a forumla, that i can put in row A column 1, then copy it down and it'd flag any emails that do NOT contain a valid domain.
basically if column a contains .com, .org, .net, .??, etc etc
full list -- http://data.iana.org/TLD/tlds-alpha-by-domain.txt
so it'd flag a valid entry with the number one, anything else would be blank.
is what im asking possible ?