| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
If "xxxx" is in a cell, then TRUE
I want to look at a cell and if the word "ave" appears anywhere in the cell
then I want a return of TRUE. I think that EXACT, OR or IF will work somehow but I want true if the word is "old ave', "1735 fairmont avenue" or "good aver", not only "ave" by itself. |
|
#2
|
|||
|
|||
|
Hi!
Try this: =ISNUMBER(SEARCH("ave",A1)) Biff "Tommy Boy" wrote in message ... I want to look at a cell and if the word "ave" appears anywhere in the cell then I want a return of TRUE. I think that EXACT, OR or IF will work somehow but I want true if the word is "old ave', "1735 fairmont avenue" or "good aver", not only "ave" by itself. |
|
#3
|
|||
|
|||
|
One way
=IF(ISERROR(FIND("ave",A1)),FALSE,TRUE) "Tommy Boy" wrote in message ... I want to look at a cell and if the word "ave" appears anywhere in the cell then I want a return of TRUE. I think that EXACT, OR or IF will work somehow but I want true if the word is "old ave', "1735 fairmont avenue" or "good aver", not only "ave" by itself. |
|
#4
|
|||
|
|||
|
One more...
=COUNTIF(A1,"*ave*")0 Tommy Boy wrote: I want to look at a cell and if the word "ave" appears anywhere in the cell then I want a return of TRUE. I think that EXACT, OR or IF will work somehow but I want true if the word is "old ave', "1735 fairmont avenue" or "good aver", not only "ave" by itself. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| blank cell turns to 0 | New Users to Excel | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Linear Mode
