In a blank column next to your data, enter the following formula
and copy down as far as you need to go.

=LEN(A1)250

This will return TRUE and FALSE values. Now, auto-filter on TRUE.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Kamran" wrote in message
...
I'm trying to find all the cells in a column that have more
than 250
characters. I've tried using DataFilterAdvanced, but haven't
been able to
figure it out. I appreciate any help.