And this formula:
Counts all cells in A1:A100 that contain exactly 3 characters.
For numeric data, you might uselogical operators.
More general information on formula criteria here.
Functions that support wildcards
Not all functions allow wildcards.
Wildcard
A wildcard is a special character that lets you perform "fuzzy" matching on text in your Excel formulas. For example, this formula:
