View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
captain bob captain bob is offline
external usenet poster
 
Posts: 1
Default sort e-mail address


I want to sort a data base. In a column, I have e-mail address
information. however some of the data is incorrect. I want to remove
all data that does not have a @ in the line. and keep all other.

Thanks
Bob


--
captain bob
------------------------------------------------------------------------
captain bob's Profile: http://www.excelforum.com/member.php...o&userid=36988
View this thread: http://www.excelforum.com/showthread...hreadid=567091