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

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

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