sort e-mail address

[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

[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

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



"captain bob" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>