Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF CONTAINS
Could someone help please?
I am looking for the Excel formula equivalent of the ?SQL command that will return true or false dependent on a text string being found in a particular cell. Thanks. Bill Ridgeway Computer Solutions |
#2
|
|||
|
|||
=ISNUMBER(FIND("text",A1))
if case sensitive =ISNUMBER(SEARCH("text",A1)) if not -- HTH Bob Phillips "Bill Ridgeway" wrote in message ... Could someone help please? I am looking for the Excel formula equivalent of the ?SQL command that will return true or false dependent on a text string being found in a particular cell. Thanks. Bill Ridgeway Computer Solutions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|