Splitting MASSIVE excel sheet + Filtering rows with profanity

Background: I have a massive excel document of over 1.5 million rows. The document consists of 3 columns: name, state, zip and the rows are separated by the state column. What i'm trying to do is the following:

1. Split these into separate documents by state. Right now I'm scrolling through trying to find where one state ends and the other begins. It's taking forever. Is there an easier way?

2. Remove any rows that have common profanity, e.g., "****, ****, etc." If I had a complete list of words I want to filter out, is there something I can do to automate it?

Any help would be appreciated.

Thanks.

Thanks for the reply. Please check your inbox.

Hi all,

Here is a sample of what the spreadsheet may look like. They need to be saved in .csv.

sample.csvsample.csv

overview:
• The rows are: first, last, state, zip.
• The document is filtered by state.

Questions:
1. Is there an automated/quick way to split this file by state (e.g., all rows with "MA" go into one file.)
2. Is there a way to then find and remove names that include profanity (e.g., the word **** is scattered throughout the document. I'd like those entries deleted automatically if possible.)

Thanks.