Using Advanced Filter for Text searches
Posted by Michael on January 18, 2002 2:46 PM
I have made an unsuccessful attempt to use the advanced filter to filter for exact words in a text list. This is likely an easy question many of you can answer in your sleep, but I would appreciate any feedback.
I have a spreadsheet with various columns of data. One of the columns contains strings of text, usually full sentences. Within this column, I have a number of rows of data with key phrases of text (e.g., "free software", "new software", "free offer", "good deal") that I am interested in seeing. I would like to query for specific phrases and then see the results of this query. For example, if I query for "free" I would like to see data for all of the rows that contain the word free.
I have used the wildcard * before words (e.g, *free) to query, but the results are sporadic - sometimes I see the data but often the desired results to do not appear.
I am not looking for any true/false results - I actually want to see the row of data that contains the text I am using to query. The text values used in the query may change frequently as well, so the query needs to be flexible.
Are there additional wildcards I should use? Formatting issues relating to text? Should I use a different approach?