Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Posts
    174
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Search for partial match (Excel 2003)

    Is there something like =IF(A1="*abc*",yes,no)..... What I am trying to do is to look at a record, if there is a string "abc" there, no matter they appear alone or as part of a word such as "xabc" or "yabcz", it would respond.

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Perth, Western Australia, Australia
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Search for partial match (Excel 2003)

    something like
    =IF(ISERROR(FIND("abc",A3)), "no", "yes")

Posting Permissions

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