Hi, I am trying to evaluate whether a string contains certain text, I have used the "Find" and "Search" functions but get an error message when the text I am searching for is not in the string, Help?
Hi, I am trying to evaluate whether a string contains certain text, I have used the "Find" and "Search" functions but get an error message when the text I am searching for is not in the string, Help?
Perhaps...
=ISNUMBER(SEARCH("test", A2))
Or ...
=COUNTIF(A2,"*String*")
Awesome, thank you for your help.
Thank you for your help, now 2 ways to find.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks