I have an excel spreadsheet with names and addresses. How do I delete rows containing Queens or other data?
March 12th, 2009
nick t asked:
I have created an excel spreadsheet with multiple rows and columns of customers. The first column is name, second house number, third town, fourth state and fifth is the zip code. There are 50,000 listings. I want to search all rows that contain “Staten Island”. Is there a way or a program to auto search and delete rows containing this data? I cant afford to do it manually as it would take hours.
Alyson
I have created an excel spreadsheet with multiple rows and columns of customers. The first column is name, second house number, third town, fourth state and fifth is the zip code. There are 50,000 listings. I want to search all rows that contain “Staten Island”. Is there a way or a program to auto search and delete rows containing this data? I cant afford to do it manually as it would take hours.
Alyson
