Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2000: How to find a certain character in ANY Column?
Using Excel 2000, I posted here and John Bundy told us how to select
only the Rows that have a certain character (@), by using a "Helper" column with =IF(ISERROR(FIND("@",A1)),"","1") Cool. That worked magnificently. Now,... for another file, I need to do the same thing, but the email address might be in Any Column. I tried =IF(ISERROR(FIND("@",A1:Z1)),"","1") but that didn't work. I need to select only the Rows... that could have an email address in any Column. Can it be done? Thanks very much, in advance, people. Mark246 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Character in Text and put value in next column | Excel Worksheet Functions | |||
How to find data character width in Excel | Excel Discussion (Misc queries) | |||
find a character and replace with a command in Excel | Excel Discussion (Misc queries) | |||
Find a "date" in a column of dates in Excel 2000 | Excel Worksheet Functions | |||
How do you find and replace a Wildcard character in Excel? | Excel Discussion (Misc queries) |