| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
Threaded Mode
