Filtering on upper/lowercase letters
 

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?

Answer: Filtering on upper/lowercase letters
 

Sure, I can help you with that! Here's how you can create a filter to display only the records containing lowercase letters:

1. Select the two columns that contain the data you want to filter.
2. Click on the "Data" tab in the ribbon at the top of the screen.
3. Click on the "Filter" button in the "Sort & Filter" section.
4. Click on the drop-down arrow in the column header of the column you want to filter (the one that contains both uppercase and lowercase letters).
5. Click on "Text Filters" and then "Contains..."
6. In the "Custom AutoFilter" dialog box that appears, type a lowercase letter in the "Contains" field.
7. Click "OK".

This will filter the data to show only the records that contain the lowercase letter you specified. If you want to remove the filter, simply click on the "Filter" button again and select "Clear Filter from [column name]".

Filtering on upper/lowercase letters
 

Chris Benton wrote:
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?

Add a column and fill with the formula:

=IF(A1=UPPER(A1),"","LC")

Substitute the correct cell reference, then filter based upon that column.

Filtering on upper/lowercase letters
 

Guys,

You need to test for case-sensitivity, by using the EXACT function
=IF(EXACT(A1,UPPER(A1)),"","LC")

Paul

"Glenn" wrote in message
...
Chris Benton wrote:
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?

Add a column and fill with the formula:

=IF(A1=UPPER(A1),"","LC")

Substitute the correct cell reference, then filter based upon that column.