Microsoft® Excel® based database addin

 
+ Reply to Thread
Results 1 to 5 of 5

Thread: wildacrds

  1. 03-20-2010 08:52 AM #1
    Dave Guest

    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.
    Reply With Quote Reply With Quote  
  2. 03-20-2010 10:01 AM #2
    Fred Smith Guest

    Default Re: wildacrds

    No. You need to use functions like Find or Search, as in:
    =isnumber(search(b1,a1))

    Regards,
    Fred

    "Dave" <Dave@discussions.microsoft.com> wrote in message
    news:B7ACAC8F-2F74-4554-809C-23C01693C242@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.

    Reply With Quote Reply With Quote  
  3. 03-20-2010 10:01 AM #3
    Gary''s Student Guest

    Default RE: 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.
    Reply With Quote Reply With Quote  
  4. 03-20-2010 10:32 AM #4
    Dave Guest

    Default Re: 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" <Dave@discussions.microsoft.com> wrote in message
    > news:B7ACAC8F-2F74-4554-809C-23C01693C242@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.
    >
    > .
    >
    Reply With Quote Reply With Quote  
  5. 03-20-2010 04:23 PM #5
    G Ray Guest

    Default Re: 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 <D...@discussions.microsoft.com> 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.

    Reply With Quote Reply With Quote  
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules