| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
an if( statement looking for a specific phrase anywhere in a cell
=IF(ISNUMBER(SEARCH(A1,"abc")),"found","not found")
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "ozarksons" wrote in message ... I want to have an if( statement evaluate a cell and see if it contains a certain text word or phrase, anywhere in the cell, and if so perform x , if not y. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
an if( statement looking for a specific phrase anywhere in a cell
I want to have an if( statement evaluate a cell and see if it contains a
certain text word or phrase, anywhere in the cell, and if so perform x , if not y. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
an if( statement looking for a specific phrase anywhere in a c
Great answer, thanks except you had it backwards...
=IF(ISNUMBER(SEARCH("abc",A1)),"found","not found") "Bob Phillips" wrote: =IF(ISNUMBER(SEARCH(A1,"abc")),"found","not found") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "ozarksons" wrote in message ... I want to have an if( statement evaluate a cell and see if it contains a certain text word or phrase, anywhere in the cell, and if so perform x , if not y. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
an if( statement looking for a specific phrase anywhere in a c
I keep getting that wrong <g
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "ozarksons" wrote in message ... Great answer, thanks except you had it backwards... =IF(ISNUMBER(SEARCH("abc",A1)),"found","not found") "Bob Phillips" wrote: =IF(ISNUMBER(SEARCH(A1,"abc")),"found","not found") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "ozarksons" wrote in message ... I want to have an if( statement evaluate a cell and see if it contains a certain text word or phrase, anywhere in the cell, and if so perform x , if not y. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with an embedded IF statement | Excel Worksheet Functions | |||
| Returning Specific Cell Content using IF Statement | Excel Discussion (Misc queries) | |||
| delete cell that doesn't contain a specific word | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
