View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
suestew suestew is offline
external usenet poster
 
Posts: 29
Default Can I filter for "number of characters in a cell"?

Never mind, I figured it out!!! You're a genius!

"Dave Peterson" wrote:

Use another column with formulas like:
=len(a2)
and drag down

Then you can include this column in your autofilter range.

suestew wrote:

I want to filter all the cells that have more than 1000 characters.


--

Dave Peterson