Filtering/sorting on upper/lowercase

C

Chris Benton

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtering on upper/lowercase letters 2
Filtering/sorting question 0
upper case lower case 0
help with finding lowercase characters in table 3
Counting Characters in cells 9
Counting Uppercase and Lowercase separately 4
filtering to separate upper & lower case 5
CHANGING FROM UPPER TO LOWERCASE IN WORKS WORD V.9 2

Top