sort e-mail address

C

captain bob

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
 
R

Ron de Bruin

Hi

You can use Autofilter to filter the column

Custom>Does 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 F5>Special>Current region>OK
3) Press Alt ; (Alt plus the semicolon) to select all visible data or F5> Special .... "Visible cells only"
4) Edit>Delete Rows
 
Top