Function that searches for a substring & returns a BOOLEAN result?
As the title indicates, I'm wondering if there's an elegant alternative to the FIND function which simply returns TRUE if the substring is found and FALSE if not. Receiving a #VALUE! error when the substring is not found isn't helpful at all.
March 30th, 2015 3:36pm
You could use
=ISNUMBER(FIND(find_text,within_text))
for a case-sensitive search, and
=ISNUMBER(SEARCH(find_text,within_text))
for a case-insensitive search.
Free Windows Admin Tool Kit Click here and download it now
March 30th, 2015 4:32pm
Thanks!
March 31st, 2015 9:57am