You could add another column to your table, and use it to check for the
exact entry. For example, assuming characters are in column D --

In cell K1, type the character you want to filter for.
In cell E1, type the heading, "Check"
In cell E2, enter the formula: =EXACT(D2,$K$1)
Copy the formula down to the last row of data
Filter the Check column for TRUE

will A wrote:
Am using XP, Excel 2002. Have no problem when using Excel 1997. The problem
is filtering single characters like a,b,c A,B,C. I am getting either only a
or only b or only c when you hit the arrow key. If you choose any character,
say a the filtered rows will give you a and A. Do I need to set up anything
in Options just to distinguished upper from lower case? This never happens
to me in Excel 1997.
thanks, (second request, no respond from MS yet from my first request)


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html