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 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
 
D

Dave Peterson

=IF(ISNUMBER(SEARCH("@",A2,1)),A2,"")
or
=if(countif(a2,"*@*"),a2,"")

Or just apply Data|filter|autofilter
Contains
@
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting cells containing formulas with blank results 3
How to include text (comment) in numeric formula? 6
Mandatory and optional formula 5
Formatting Cell that Contains If/Then Formula 5
if(isna(match formula 8
Stuck - need help on an if/conditional formula 1
Count with merged cells 2
adding cells upto and including a specified cell 6

Top