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

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

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.


"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
>

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
>

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)

On Mon, 15 Dec 2008 11:39:05 -0800, suestew
<(E-Mail Removed)> wrote:

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