Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Test for email addresses
I have a large (~10,000) list of former clients in an excel file that was
created when I pulled a report from my third party software. I've contracted with a newsletter company to help stay in touch with them. The newsletter company charges by entry so I need to delete any rows that aren't email addresses. I've already found the marco that deletes duplicate entries, and I can easily sort to get rid of entries with no email address, now I need some way to delete entries that have something other than an email address in the "email address" column. The answer could be several things: a helper column that tests for wildcard@wildcard, or a macro that tests and deletes rows. I haven't been able to get anything to work yet. Any help is appreciated. Regards, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help finding non-duplicate email addresses... | Excel Discussion (Misc queries) | |||
Help needed...test score statistics | Excel Discussion (Misc queries) | |||
comparing test scores over a few years | Excel Discussion (Misc queries) | |||
copy/convert column email addresses Hyperlink "mailto:" excel97 | Excel Discussion (Misc queries) | |||
Copy Excel email addresses to GroupWise | Excel Discussion (Misc queries) |