+ Reply to Thread
Results 1 to 7 of 7

Finding a text string in a column

Hybrid View

booo Finding a text string in a... 10-29-2010, 07:24 PM
TMS Re: Finding a text string in... 10-29-2010, 07:32 PM
booo Re: Finding a text string in... 10-29-2010, 07:46 PM
mikerickson Re: Finding a text string in... 10-29-2010, 09:48 PM
shekar goud Re: Finding a text string in... 10-29-2010, 10:22 PM
mikerickson Re: Finding a text string in... 10-30-2010, 12:19 AM
TMS Re: Finding a text string in... 10-30-2010, 04:04 AM
  1. #1
    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"

  2. #2
    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 to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1