3

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.

3

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

1

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

=LEN(A1)
  • 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