If cell does not include @, then blank
 

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


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=501199

If cell does not include @, then blank
 

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

Or just apply Data|filter|autofilter
Contains
@




jermsalerms wrote:

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

--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=501199

--

Dave Peterson

If cell does not include @, then blank
 

you have been a big help on several occasions for this project


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=501216