| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filtering on String Length
"Tom Ogilvy" wrote in message
... in an adjacent column, but in the formula M2: =len(B2) Range("M2:M200").Formula = "=Len(B2)" then apply your filter to column M. Spot on, working a treat. Thanks Tom. Keith. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Zero-Length string vs Zero (also a valid value) | Excel Worksheet Functions | |||
| Finding a string of unknown length in a string of unknown length, Help! | Excel Discussion (Misc queries) | |||
| String length | Excel Discussion (Misc queries) | |||
| string length | Excel Programming | |||
| Counting string length | Excel Programming | |||
Hybrid Mode
