wildacrds
 

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.

wildacrds
 

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.

wildacrds
 

=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.

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.

.

wildacrds
 

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.