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

sort e-mail address
 

Hi

You can use Autofilter to filter the column

CustomDoes not contain @

Then delete the visible data

1) Be sure that the active cell is in the data range
2) Press Ctrl * to select all data or use F5SpecialCurrent regionOK
3) Press Alt ; (Alt plus the semicolon) to select all visible data or F5 Special .... "Visible cells only"
4) EditDelete Rows

--
Regards Ron de Bruin
http://www.rondebruin.nl



"captain bob" wrote in message
...

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