cells A2:A901 contain email addresses.

some say n/a, none, no, etc.

I want to filter all those out...so I am trying to figure out how to write a formula that will only display the cell if the is and @ symbol included.

Im not sure what function will search for a peticular character and how to write the formula