Aug 15, 2001 #1 umaine Technical User Sep 26, 2000 2 US I have a large excel spreadsheet with over 60k email addresses. Some do not have @yourcompany.com. How do I sort or list these invalid email addresses for exclusion in a mailing? Many thanks! Martin Beall
I have a large excel spreadsheet with over 60k email addresses. Some do not have @yourcompany.com. How do I sort or list these invalid email addresses for exclusion in a mailing? Many thanks! Martin Beall
Aug 15, 2001 #2 Databaseguy MIS Jul 20, 2001 1,153 US =IF(FIND("@",A1)<>"",Something, Something Else) Tyrone Lumley augerinn@gte.net http://server47.hypermart.net/databaseguy Upvote 0 Downvote
=IF(FIND("@",A1)<>"",Something, Something Else) Tyrone Lumley augerinn@gte.net http://server47.hypermart.net/databaseguy