Microsoft KB Archive/41624

-

{| 2.x 3.00 4.00 5.00 |2.20 2.21 3.00 | 2.20 3.00 4.00 5.00 WINDOWS           | OS/2          | MACINTOSH kbusage The information in this article applies to:
 * width="100%"|


 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 5.0
 * Microsoft Excel for OS/2, versions 2.2, 3.0
 * Microsoft Excel for the Macintosh versions 2.2, 3.0, 4.0, 5.0

SUMMARY
Microsoft Excel supports the use of wildcards such as &quot;*&quot; and &quot;?&quot; in a database criteria only when searching a column of text. A column of values will not extract properly with wildcards in the criteria. Once you use a wildcard in a criteria, the criteria is treated as text; comparing a text criteria to a value will never be equal.

MORE INFORMATION
The following is an example of a method to simulate the use of wildcards to search a column of values:

A1:  Name    B1: Zip A2:  Joe     B2: 98121 A3:  Jim     B3: 98345 A4:  Mary    B4: 98223 A5:  John    B5: 12345 When extracting all of the people that had names that started with &quot;J&quot;, the criteria would look like the following: D1: Name D2: J* Choosing Extract from the Data menu would then extract a list that looks like the following: Name Joe Jim John To do the same thing with the zip code, such as extract every zip code that starts with &quot;98&quot;, the criteria would be: D1: D2: =LEFT(TEXT(B2,&quot;##&quot;),2)=&quot;98&quot; Note the blank cell, D1. Using a blank as the column title for the criteria tells Excel that you are using a computed criteria. Using the above criteria and then choosing Extract from the Data menu would extract a list that looks like the following:

Zip 98121  98345   98223 In Microsoft Excel version 5.0, you can filter your data more easily than performing an extract. To filter your information, choose Filter from the Data menu, then choose Advanced Filter and enter the criteria.