Results 1 to 7 of 7

Thread: wild card

  1. #1
    Join Date
    Aug 2012
    Posts
    29

    Unanswered: wild card

    I have a formula col=1 but I want to add a wild card

    Can any one help thanks

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Imagine we're searching for "aa":

    Not case sensitive
    Code:
    =IFERROR(SEARCH("aa", A1), 0) > 0
    Case-sensitive
    Code:
    =IFERROR(FIND("aa", A1), 0) > 0
    George
    Home | Blog

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Another option:
    Code:
    =A1<>SUBSTITUTE(A1,"aa","")
    George
    Home | Blog

  4. #4
    Join Date
    Aug 2012
    Posts
    29
    Thanks but if I have this code how do I add it
    If txtimporter <> "" Then
    col = 1 ' "A"
    strFind =txt importer
    End If

  5. #5
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Ahh, you never said you were playing in VBA!
    Quote Originally Posted by kim40
    I have a formula ...
    hence why I provided a formula solution.

    Any reason the formula won't work for you?
    George
    Home | Blog

  6. #6
    Join Date
    Aug 2012
    Posts
    29
    Thanks but I have a user form so I would like to work within that

  7. #7
    Join Date
    Feb 2013
    Posts
    15
    i DON'T understand what are you saying......?

Posting Permissions

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