View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nautico Nautico is offline
external usenet poster
 
Posts: 3
Default 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.