Filtering out rows with an empty column A
 

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.

Filtering out rows with an empty column A
 

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

Do make a backup just in case.

"Nautico" wrote:

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.

Filtering out rows with an empty column A
 

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" wrote:

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

Do make a backup just in case.

"Nautico" wrote:

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.

Filtering out rows with an empty column A
 

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" wrote:

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" wrote:

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

Do make a backup just in case.

"Nautico" wrote:

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.

Filtering out rows with an empty column A
 

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

"Sheeloo" wrote:

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" wrote:

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" wrote:

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

Do make a backup just in case.

"Nautico" wrote:

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.