On Mar 6, 10:52 am, "Bernard Liengme"
wrote:
1) delete them
2) move them to another column
3) use a helper column with 0, 1 (0 meaning do not email); use this to
filter on
4) change @ to % so the email goes no where
....
best wishes

--
Bernard V Liengmewww.stfx.ca/people/bliengme
remove caps from email

"Jan" wrote in message

oups.com...

In one column I have like 2000 email addresses my potential clients
and some of them do not want to receive any emails at all. So I have
about 10 email address that I can not send to. Can someone please help
me with a formula that will eliminate all of those restricted (10
emails) addresses from that main column?
Thank you.
Jan

Thank you guys, you've helped me a lot.
Jan