How can I find all cells that do NOT contain an "@" symbol?

  • Thread starter Thread starter Gregg Hill
  • Start date Start date
G

Gregg Hill

Hello!

I am trying to filter a list over nearly 4000 email addresses. Some of the
entries are bogus and do not contain an "@" symbol. Is there an easy way to
find and sort by these cells so I can delete them?

Thanks!

Gregg Hill
 
Click on Data>Filter>Auto Filter and set a custom filter so that "show rows
where"
"does not contain" and enter "@" into the next field. CLick OK and you
should end up with a list where the e-mail address has no @ in it.
 
Try an advanced filter:

Assumption: your email list is in begins in cell A1 with the word EMAIL in
Cell A1.

Build a criteria range of 2 vertically contiguous cells.
example:
C1: EMAIL
C2: <>*@*

That criteria will look for cells that DO NOT match the pattern.

Select the email range, then
Data>Filter>Advanced Filter

List Range: (your list)
Criteria Range: C1:C2
Click [OK]

If you want to eliminate the non-email lines, select the displayed results
then: Edit>Delete>Rows

Does that give you something to work with?

Regards,
Ron
 
Back
Top