Maybe use a helper col ..

Assuming source text in A2 down
In B2, copied down:
=IF(A2="","",IF(AND(CODE(LEFT(A2))=65,CODE(LEFT(A 2))<=90),"Upper",IF(AND(CODE(LEFT(A2))=97,CODE(LE FT(A2))<=122),"Lower","")))
will flag upper/lower as desired, based on the leftmost character. Then just
apply/use autofilter on col B

Success? Hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"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 ?