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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gregg Hill - 19 Jun 2005 23:44 GMT

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

Reply to this Message

bigwheel - 20 Jun 2005 00:07 GMT

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.

> Hello!
>
[quoted text clipped - 5 lines]
>
> Gregg Hill

Reply to this Message

Gregg Hill - 20 Jun 2005 00:18 GMT

Dang, you guys are QUICK! Thank you, that was easy!

Gregg Hill

> Click on Data>Filter>Auto Filter and set a custom filter so that "show
> rows
[quoted text clipped - 13 lines]
>>
>> Gregg Hill

Reply to this Message

Ron Coderre - 20 Jun 2005 00:07 GMT

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

Reply to this Message