a for each loop looking for INSTR "@" might do it for you

--
Don Guillett
SalesAid Software

"Lewis Shanks" wrote in message
...
In data bases that I have with large numbers of email addresses in one
column, I wish to be able to look through the whole column to find (and
possibly highlight) all emails that do not have the @ sign listed. This
will
allow me to delete those that are invalid addresses. Also, I wish to look
up, in another column, all entries that have selected key words so that I
can also delete these selected entries.

Suggestions?

Lewis