Find email addresses and Replace with blank

[guru420]

Hi , I have an exel customer list of over 10000 customers, about 500 of them chose not be connacted by email.
How do I go about deleting the email addresses only of those customers without having to use Ctrl+F then delete one by one?
I do not want to delete the row just the email address in a cell.
Thanks

[ChemistB]

Lets say your emails are in Column B and customer names in Col A. I'm assuming you have a list of these 500 customers so we'll paste that into G1:G500

If your customers start in row 2 and Col F is empty
In F2
=IF(ISERROR(MATCH(A2,$G$1:$G$500,0)),"", "Delete")
Drag that down to find all matches. Then Filter on Delete, select column B and clear contents. Does that work for you?

[guru420]

Hi ChemistB,
Thanks. I have Column A = Id#, B= last name, C = first name, D =address, E= state, F= postcode, and J= email address.
I have the list of email addresses only of the 500 customers who chose to unsubscribe.
Thanks

[scottylad2]

Your list of customers with the unsubscribe, is that in the same format? or does that list contain 1 column which holds the entire details for the client that wishes to unsubsctibe, can you upload a small sample of both lists? would make it easier

[guru420]

Thanks ChemistB.
I run your formula to match email addresses and it worked.
Thank you very much
Regard
PS. Not sure how mark this post as "Solved"