View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris Benton Chris Benton is offline
external usenet poster
 
Posts: 5
Default Filtering/sorting question

In Excel 2007, I have records that contain both uppercase and lowercase
letters in two columns. I need to create a filter so that ONLY the records
containing lowercase letters are shown. I don't need to convert the case, I
just need to see which rows contain lowercase. The sheet contains over 4,000
rows, so I don't relish having to do it manually. Haven't been able to do
this on my own. Thoughts?