If cell does not include @, then blank

J

jermsalerms

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 t
write a formula that will only display the cell if the is and @ symbo
included.

Im not sure what function will search for a peticular character and ho
to write the formul
 
S

Sloth

Use the auto filter command and select custom. Select Contains and put @ in
the formula box.
 
Top