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.
Bookmarks