You probably could do better with VBA, but try this.
Copy your addresses to a new worksheet
Replace Replace what:= *@*.???
All the BAD will remain


"Becky" wrote:

Hi. I'm not sure I'm in the right forum, but here goes.

Given a list of several hundred e-mail addresses in a column of an Excel
worksheet, is there a good way to identify invalid addresses? (for example,
if the '@' is missing) ?

thanks in advance
Becky