Find solution
How to sort email addresses?

Panning for email addresses

  • 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.

  • Answer:

    =ISNUMBER(FIND("@",A1)) will return "true" if there's an @ sign in A1 and "false" if there isn't.

FatherDagon at Ask.Metafilter.Com Visit the source

Was this solution helpful to you?

Other answers

An easy way to do this would be to use a program that just extracts complete email addresses. Obviously this would not test the validity of a properly formatted email address, but it would be the first step you are looking for. Try these guys: http://emailx.discoveryvip.com/

yoyoceramic

(and then obviously you can sort by that column of trues and falses and the ones with an @ sign will all group together)

brainmouse

Bingo, that's what I'm looking for! Thanks.

FatherDagon

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.