How to filter a CSV file with just 1 column?

Hello,

I was wondering, I have a CSV file which I want to split up. When I open it in Excel it opens all in column A, so can't filter it on a certain column. Now, I want to filter out the email addresses which all contain the @ which the other columns don't. Is it possible to filter those out in any way? Help would be appreciated.

Thanks

Do this:
1) Highlight the column you want to sort
2) Click on the "Data" tab
3) Choose "Text to Columns"
4) Click "Delimited" then "Next"
5) Choose the separator you want to use
6) Click next and finish

This is for Excel only BTW.

Create a database using php or any other programing language. You can get one field to emails.