Forum Discussion
How to delete specific email ids from MS Excel 2007.
Maybe try something like this based on the description you've given (See attached .xlsx file for reference):
Maybe try something like this based on the description you've given (See attached .xlsx file for reference):
Hi Matt, it worked very well. Thank you :)
Thank you Matt and Pooja for these contribution though I am following the steps but it hasn't worked for me. Kindly provide clear STEPS. Thank you in advance awaiting your swift respone... Godfrey
What exactly doesn't work?
You generate helper column as in sample, apply filter to it on "Delete Me"
select these two rows, Home->Delete cells and confirm deleting
after clear filter from helper column
and delete helper column if not it's not needed any more.
I am unable to get results. It showed some emails in Column A but those are not from Column B. Kindly explain more on the issue.
Can you please provide some kind of non-sensitive sample mockup file for the community to test their solutions on? The formula I provided should contain a text string in Column C (not an email) indicating whether you need to delete the value in Column A. Then you can just filter on Column C and delete the emails in the filter, leaving only the emails that you do not wish to delete.
