When entering values on which you want to search, you can use a partial value. For example, to find any value that contains the string "test", you would enter test and clear the Case Sensitive check box. This would locate values such as Test case, Amy's testing results, Sales Contest. This is known as using an "implied wildcard."
The sort order of the collection determines the order in which you find matching records.
NOTE: The Find Value and Replace Value features do not support use of the wildcard character, the Null keyword, or comparison operators. These characters in such searches are treated as literal values.