Can I filter for "number of characters in a cell"?

  • Thread starter Thread starter suestew
  • Start date Start date
Use another column with formulas like:
=len(a2)
and drag down

Then you can include this column in your autofilter range.
 
Yeah - thank you.

So if I want the length to be 1000 or more, what would that look like?

=len(1000) or just pick a cell that has more than 1000 and go off that one?

I'm assuming your a2 below refers to a cell with the length of characters I
am trying to filter.
 
The easiest way to do this is to insert a column next to the test data
and use the formula =LEN(A1)>1000 . This will return TRUE or FALSE for
each cell. Filter on the TRUE values of this column.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
You must log in or register to reply here.

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

Individual Character fonts in a cell 12
Advance Filter 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Macro that will insert a simple text string in top cell of text file 1
Column Cell character number checking 4
Eliminating cells 3
Is it possible to just act on the filtered data 2
No characters data in Hyperlink cell 3

Back
Top