Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2003
    Location
    Birmingham, England
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts
    A1 contains something like
    DEPOSITPOINT 501373
    A2 contains the formula
    =A1="*501???"
    It returns the value FALSE
    I think that A1 does contain the specified string, so the result should be TRUE.
    What's wrong?
    JRR

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    It fails since you are testing whether A1 is literally the string "*501???" which it is not.

    You can use (depending on what you want:

    =ISNUMBER(SEARCH("501", A1))
    to see if it contains ANY "501" though could be at end of string or even:

    =COUNTIF(A1,"=*501???")>0

    Steve

  3. #3
    New Lounger
    Join Date
    May 2003
    Location
    Birmingham, England
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You're a star, Steve.
    If you do a custom filter, the criteria handle wildcards: but not, it seems, the formula.
    Not in the same way, anyway.
    Thanks again
    JRR

Posting Permissions

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