Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default 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?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Upper to Lowercase in Excel Beth Excel Worksheet Functions 7 July 17th 08 04:35 PM
Sorting and filtering HELP!!!!! Yossy Excel Worksheet Functions 2 May 12th 08 04:38 AM
Sorting/Filtering Brandy Excel Discussion (Misc queries) 5 February 11th 08 09:02 PM
convert a range of lowercase text to upper text or vice versa jackdaw Excel Worksheet Functions 2 May 16th 05 09:31 PM
Sorting and filtering dsbiloxi Excel Worksheet Functions 7 March 10th 05 11:55 PM


All times are GMT +1. The time now is 01:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"