kingfisher wrote:What about using FIND or SEARCH? Either function can be combined with ISNUMBER if you want to avoid an error result.
function that would search not for an exact match but for a substring.
kingfisher wrote:I was looking at the thread title and these words in the o.p. (emphasis added):function that would search not for an exact match but for a substring.
I took 'substring' to mean part of the text.
BTW, I hope my avatar does not eat your avatar; that would be bad manners.
Villeroy wrote:Currently there is no way to enable matching by wildards in Calc.
Users browsing this forum: RusselB and 40 guests