It works so you must have applied it incorrectly, you need to have a header,
if you want to filter in place it's easier if you insert a couple of empty
rows at the top, also make sure that the criteria includes 2 cells, one
empty above and the one with the formula below so if the formula is in H2
use H1:H2 for the criteria. Or you can use Chips method copying the formula
down in a help column and filter autofilter on that help column



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Kamran" <Kamran@discussions.microsoft.com> wrote in message
news:2FE80F28-16BD-4DC1-9D26-1C21B6ABD2E6@microsoft.com...
>I appreciate the replies, but I've been unable to make it work. My data is
> in column F, heading in F1, data starting in F2. Using the suggested
> formula
> [in my case, =LEN(F2)>250], it hides all rows, I think because cell A6 has
> less than 250 char and therefore the criterion is not met. Shouldn't it
> be
> checking the F column independently for every row, e.g., =LEN(F2)>250,
> =LEN(F3)>250, =LEN(F4)>250 ?
> The only way I've been able to make it work is to copy the F column
> heading
> into a blank column, and the enter 250 question marks into the cell below
> and
> use that for the Advanced Filter.