Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If cell does not include @, then blank
cells A2:A901 contain email addresses. some say n/a, none, no, etc. I want to filter all those out...so I am trying to figure out how to write a formula that will only display the cell if the is and @ symbol included. Im not sure what function will search for a peticular character and how to write the formula -- jermsalerms ------------------------------------------------------------------------ jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167 View this thread: http://www.excelforum.com/showthread...hreadid=501199 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If cell does not include @, then blank
Use the auto filter command and select custom. Select Contains and put @ in
the formula box. jermsalerms" wrote: cells A2:A901 contain email addresses. some say n/a, none, no, etc. I want to filter all those out...so I am trying to figure out how to write a formula that will only display the cell if the is and @ symbol included. Im not sure what function will search for a peticular character and how to write the formula -- jermsalerms ------------------------------------------------------------------------ jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167 View this thread: http://www.excelforum.com/showthread...hreadid=501199 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get a formula result zero as blank cell | Excel Discussion (Misc queries) | |||
Replace null string with blank cell | Excel Discussion (Misc queries) | |||
leave a cell blank | Excel Worksheet Functions | |||
blank cell turns to 0 | New Users to Excel | |||
Custom format that shows blank cell if another cell is empty | Excel Discussion (Misc queries) |