In Excel 2007, I want to filter rows by one of my columns text length, eg. hide the rows with text lengths less or greater than 12 characters. what should I do?

migrated from stackoverflow.com Oct 26 '10 at 13:31

This question came from our site for professional and enthusiast programmers.


you can use an autofilter. select 'custom', choose 'equals', and enter 12 question marks for the criteria.


In another column, create a formula that shows the length of the target column... fill it down, and then filter based on that column.

  • yeah, but how do you filter... – BugWhisperer Jul 17 at 23:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy