Select certain rows

[rainrainrain]

Hello!

I have an excel file with over 5000 names. The column headers are (First name, Last name, address, email, so on and so forth)

I need to separate this list from the people who have emails and the people who do not.

Is there a way to select the "rows" that contain emails.

Sorry I'm a noob! Any help would be appreciated so I do not need to have a mass copy and paste fest.

Thank you!
-Rain

 

[hippiehacker]

why not filter and copy the visible cells to another sheet?

 

[rainrainrain]

How do you filter the cells? Like I said, excel novice

 

[hippiehacker]

which office version?