LinkBack URL
About LinkBacks
I've got a very large CSV file containing contact information. I need to remove all contacts that do not have a value in column M. Column M being email addresses. I'm not sure how to do this, I'm excel stupid
I've got a very large CSV file containing contact information. I need to remove all contacts that do not have a value in column M. Column M being email addresses. I'm not sure how to do this, I'm excel stupid
Presumably you have got headings to all your columns, like name, address etc. with column M being email address. Then click in the data area, go to Data > Auto-filter and select column M, in the drop down, select blanks, this will filter all the rows with blanks in M.
Select these rows and delete.
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
I cannot click on Auto filter, everything is grayed out.
Select the data area and try again?
Yeah I wasn't clicking it right. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks