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
wrote:
I want to filter all the cells that have more than 1000 characters.