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.