+ Reply to Thread
Results 1 to 7 of 7

Finding a text string in a column

Hybrid View

  1. 10-29-2010, 07:32 PM #1
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,100

    Re: Finding a text string in a column

    Use AutoFilter with a Custom Filter: Contains: "pins" no quotes

    See your updated workbook

    Regards
    Attached Files Attached Files
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  2. 10-29-2010, 07:46 PM #2
    booo
    booo is offline
    Registered User
    Join Date
    09-29-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    91

    Re: Finding a text string in a column

    That was very helpful. Is it possible that I can check for the existence of more than one word in a string?

    That is if I want to check for the existence of two words "pins" and "bent"
    Reply With QuoteRegister To Reply
  3. 10-29-2010, 09:48 PM #3
    mikerickson
    mikerickson is offline
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Finding a text string in a column

    The two word situation can be done with AdvancedFilter.
    The attached has a criteria range in G1:G3
    Attached Files Attached Files
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1