On Mon, 3 Aug 2009 23:18:01 -0700, GaryC
wrote:

I have a spreadsheet with one column data containing text, only differing by
being in either upper or lower case. I need to filter uppercase from lower
case but can't find how. Advance filter does not seem to cover case sensitive
any suggestions, perhaps another way of doing this ?

You certainly can use the Advanced Filter. You need to use formulas for
criteria.

Here is an example.

Table set starting at

A4: Data

Data Values
NOW IS 2
now is 3
FOR ALL 4
for all 5

Criteria (to extract lower case text lines)

A1: <empty cell
A2: =EXACT(A5,LOWER(A5))

Advanced Filter
List Range: $A$4:$B$8
Criteria RAnge: $A$1:$A$2

The result, is:

Data Values
now is 3
for all 5

To extract the upper case entries,
A2: =upper(a5,exact(a5))
--ron