Find where cell does not contain specific text

[ywmpp]

I have a list of email addresses and I want to find all that are not a particular company's--so I can remove any external e-mail addresses

e.g. find all that do not contain @acme.com

Appreciate your help.

 

[Joe4]

If you use the following formula on them:

=IFERROR(FIND("acme.com",A1),"not found")

each row that returns "not found" will be the ones that you want.
So you can sort or filter that column to get just the ones you want to return.

 

[ywmpp]

Thank you. I realized I have some uppercase text which above is not catching. How can I also flag those?

 

[Joe4]

Just convert it all to Lower case text within your function for comparison purposes, i.e.

=IFERROR(FIND("acme.com",LOWER(A1)),"not found")

or use the SEARCH function which is not case sensitive:

=IFERROR(SEARCH("acme.com",A1),"not found")