I have a list of hundreds of users in an Excel spreadsheet. I want to remove all of the users that don't have their email address in there spreadsheet entry. there's a column called 'email', so how would I remove all the rows with a blank 'email', without having to go through every entry and delete each one manually.
Bear in mind I'm a complete newbie on Excel; I'm not sure how to run code. Some pointers would be very helpful!