Thread: wildacrds
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default 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.