Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort excel spreadsheet with hyperlink | Excel Discussion (Misc queries) | |||
Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
Data > Sort function amnesia? | Excel Discussion (Misc queries) | |||
How Do I sort an IP address by the 3rd Octet? | Excel Worksheet Functions |