Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel that simulates LIKE or CONTAINS?
- Thread starter wandan
- Start date
Best I can suggest is:
IF(ISERR(SEARCH(find_text,within_text,start_num)),"not found","Found")
Find_text is the text you want to find. You can use the wildcard characters, question mark (?) and asterisk (*), in find_text. A question mark matches any single character; an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.
Gavin
IF(ISERR(SEARCH(find_text,within_text,start_num)),"not found","Found")
Find_text is the text you want to find. You can use the wildcard characters, question mark (?) and asterisk (*), in find_text. A question mark matches any single character; an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.
Gavin
Lilliabeth
Technical User
Here's another:
=IF(COUNTIF(A1,"*apple*")>0,"Found it","Nope")
--Lilliabeth
=IF(COUNTIF(A1,"*apple*")>0,"Found it","Nope")
--Lilliabeth
- Status