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