software

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: www.excelforum.com/member.php...oamp;userid=30167
View this thread: www.excelforum.com/showthread...hreadid=501199Use the auto filter command and select custom. Select Contains and put @ in
the formula box.

gt;jermsalermsquot; wrote:

gt;
gt; cells A2:A901 contain email addresses.
gt;
gt; some say n/a, none, no, etc.
gt;
gt; I want to filter all those out...so I am trying to figure out how to
gt; write a formula that will only display the cell if the is and @ symbol
gt; included.
gt;
gt; Im not sure what function will search for a peticular character and how
gt; to write the formula
gt;
gt;
gt; --
gt; jermsalerms
gt; ------------------------------------------------------------------------
gt; jermsalerms's Profile: www.excelforum.com/member.php...oamp;userid=30167
gt; View this thread: www.excelforum.com/showthread...hreadid=501199
gt;
gt;