wildacrds
"No" is so final!
"Fred Smith" wrote:
No. You need to use functions like Find or Search, as in:
=isnumber(search(b1,a1))
Regards,
Fred
"Dave" wrote in message
...
Hi,
XL2003.
Is it possible to use wildcards in simple logic statements?
If A1 contains "qwerty" and B1 contains "qw"
In C1 I've tried:
=A1=B1* - xl complained
=A1=B1&* -xl complained
=A1=B1&"*" - returned FALSE
Regards - Dave.
.
|