Panning for email addresses
July 29, 2011 10:03 AM Subscribe
How do I sort the (potentially) real email addresses from the garbage data in Excel 2003?
I have a column of 900+ entries of client info, where they entered something that's theoretically their email address. However, many of these are dud entries, missing their domain names, incomplete, etc. Is there a simple way to sort 900+ cells based on the presence/absence of an @ symbol? That'd be a tremendous first step in digging out the potentially real addresses from the broken ones, without having to do it all by hand.
I have a column of 900+ entries of client info, where they entered something that's theoretically their email address. However, many of these are dud entries, missing their domain names, incomplete, etc. Is there a simple way to sort 900+ cells based on the presence/absence of an @ symbol? That'd be a tremendous first step in digging out the potentially real addresses from the broken ones, without having to do it all by hand.
Best answer: =ISNUMBER(FIND("@",A1)) will return "true" if there's an @ sign in A1 and "false" if there isn't.
posted by brainmouse at 10:07 AM on July 29, 2011 [2 favorites]
posted by brainmouse at 10:07 AM on July 29, 2011 [2 favorites]
(and then obviously you can sort by that column of trues and falses and the ones with an @ sign will all group together)
posted by brainmouse at 10:08 AM on July 29, 2011
posted by brainmouse at 10:08 AM on July 29, 2011
Response by poster: Bingo, that's what I'm looking for! Thanks.
posted by FatherDagon at 10:18 AM on July 29, 2011
posted by FatherDagon at 10:18 AM on July 29, 2011
This thread is closed to new comments.
Try these guys:
http://emailx.discoveryvip.com/
posted by yoyoceramic at 10:05 AM on July 29, 2011