Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I filter for "number of characters in a cell"?
I want to filter all the cells that have more than 1000 characters.
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I filter for "number of characters in a cell"?
Use another column with formulas like:
=len(a2) and drag down Then you can include this column in your autofilter range. suestew wrote: I want to filter all the cells that have more than 1000 characters. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I filter for "number of characters in a cell"?
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. "Dave Peterson" wrote: Use another column with formulas like: =len(a2) and drag down Then you can include this column in your autofilter range. suestew wrote: I want to filter all the cells that have more than 1000 characters. -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I filter for "number of characters in a cell"?
Never mind, I figured it out!!! You're a genius!
"Dave Peterson" wrote: Use another column with formulas like: =len(a2) and drag down Then you can include this column in your autofilter range. suestew wrote: I want to filter all the cells that have more than 1000 characters. -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I filter for "number of characters in a cell"?
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Limiting a Column to "X" Number of Characters | Excel Discussion (Misc queries) | |||
Limiting a Column to "X" Number of Characters | Excel Discussion (Misc queries) | |||
The number of characters in a "Screen Tip" | Excel Discussion (Misc queries) | |||
Count number of characters until encounter "&" | Excel Programming |