From: Dave on 20 Mar 2010 04:43 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. From: Fred Smith on 20 Mar 2010 05:27 No. You need to use functions like Find or Search, as in: =isnumber(search(b1,a1)) Regards, Fred "Dave" wrote in message news:B7ACAC8F-2F74-4554-809C-23C01693C242(a)microsoft.com...> 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. From: Gary''s Student on 20 Mar 2010 05:49 =LEFT(A1,2)=B1 -- Gary''s Student - gsnu201001 "Dave" wrote: > 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. From: Dave on 20 Mar 2010 06:21 "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 > news:B7ACAC8F-2F74-4554-809C-23C01693C242(a)microsoft.com... > > 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. > > . > From: G Ray on 20 Mar 2010 11:48 What are you trying to do? Are you trying to determine if a1 and b1 are equal? Is this user input? Glen On Mar 20, 1:43 am, Dave wrote:> 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.