S
suestew
I want to filter all the cells that have more than 1000 characters.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
Use another column with formulas like:
=len(a2)
and drag down
Then you can include this column in your autofilter range.
=len(a2)
and drag down
Then you can include this column in your autofilter range.
S
suestew
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.
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.
S
suestew
Never mind, I figured it out!!! You're a genius!
C
Chip Pearson
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)
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)