Thread: wildacrds
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
G Ray G Ray is offline
external usenet poster
 
Posts: 8
Default 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.