For a one off if you were familiar and comfortable with it, then it's a maybe.
As well as cleaining up the duff addresses, some one needs to stop putting duff ones going in.
In VB. VBA or VB6 then the Split function would be a start.
Split('@') should return and array of two strings, before and after the @
0 would be an empty address
1 would be a string starting or ending with @
2 is OK
More is WTF.
You could also split the second part on . to see if you have something@something.something
VB.net, I'd be using RegEx, but that has split as well
I always have to look that sort of thing up, try here, one you've done a few .Net regex tutorials.
http://www.regular-expressions.info/email.html
THis might come in handy as well
http://www.codeproject.com/KB/vb/regextester.aspx