Filtering out rows with an empty column A

[Nautico]

I have created a .csv file by exporting only last name and email address from
my OE6 address book. In more than half of the resultant spreadsheet rows,
column A (last name) is empty. Is there any way I can eliminate all such
rows, so that the only rows that appear are those with entries in both
columns A and B?

Thanks.

 

[Sheeloo]

Filter Col A on blanks...
Select the result and delete rows...

Do make a backup just in case.

 

[Nautico]

I selected all rows of cells A (name) and B (email address), but when I
attempted to follow your instructions, the following appeared:

MS Excel cannot determine which row in your list or selection contains
column labels, which are required for this command.

 

[Sheeloo]

Looks like you don't have headers...
If you have them then select them also otherwise insert row at the top and
enter headings, then select the range including headings.

 

[Nautico]

But I do have headers, Last Name and Email Address, and they appear in
columns A and B of row 1.