ExcelBanter - Filtering/sorting on upper/lowercase

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Filtering/sorting on upper/lowercase (https://www.excelbanter.com/excel-worksheet-functions/220902-filtering-sorting-upper-lowercase.html)

Chris Benton

Filtering/sorting on upper/lowercase

In Excel 2007, I have several 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 displayed. I don't need to convert
the case, I only need to see which records contain lowercase. Haven't been
able to come up with anything on my own. Thoughts?

All times are GMT +1. The time now is 06:58 AM.