D
DR
How do I get an if statement to return true if a cell contains a text string
rather than its being entirely composed of the string? Thanks
rather than its being entirely composed of the string? Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
not quite sure what you're trying to check. Could you post an example
as plain text.
Maybe the functions
ISNUMBER
or
ISTEXT
are what you're looking for
not quite sure what you're trying to check. Could you post an example
as plain text.
Maybe the functions
ISNUMBER
or
ISTEXT
are what you're looking for
T
Trevor Shuttleworth
One way:
=IF(ISERROR(SEARCH("*text*",G22)),"not found","found")
Change the text to whatever you want to look for
Regards
Trevor
=IF(ISERROR(SEARCH("*text*",G22)),"not found","found")
Change the text to whatever you want to look for
Regards
Trevor
J
Jason Morin
=COUNTIF(A1,"*string*")
HTH
Jason
Atlanta, GA
HTH
Jason
Atlanta, GA
V
Vasant Nanavati
A bit awkward, but:
=AND(NOT(ISERROR(FIND("mystring",A1))),LEN(A1)>LEN("mystring"))
=AND(NOT(ISERROR(FIND("mystring",A1))),LEN(A1)>LEN("mystring"))
D
DR
Thanks. I'm just trying (Excel 2000) to get a true if the cell text says
"one two" where I say
IF (A1="*two*", something, something else)
It seems not to like that syntax and is giving me the false result
"one two" where I say
IF (A1="*two*", something, something else)
It seems not to like that syntax and is giving me the false result
F
Frank Kabel
Hi
one way
=IF(ISNUMBER(FIND("two",A1)),"something","something else")
one way
=IF(ISNUMBER(FIND("two",A1)),"something","something else")
D
DR
The numbers were only an example.
Frank Kabel said:Hi
one way
=IF(ISNUMBER(FIND("two",A1)),"something","something else")
F
Frank Kabel
Hi
the function ISNUMBEr only checks if FIND does find your text string.
You could also use the same formula with
=IF(ISNUMBER(FIND("mytexttosearchincell_A1",A1)),"something","something
else")
the function ISNUMBEr only checks if FIND does find your text string.
You could also use the same formula with
=IF(ISNUMBER(FIND("mytexttosearchincell_A1",A1)),"something","something
else")
V
Vasant Nanavati
Did you try my proposed solution?
--
Vasant
--
Vasant
DR said:Thanks. I'm just trying (Excel 2000) to get a true if the cell text says
"one two" where I say
IF (A1="*two*", something, something else)
It seems not to like that syntax and is giving me the false result
D
DR
Works like a charm. Thanks. Can't believe there isn't something more
pedestrian in the app.
pedestrian in the app.