| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Characters
Perfecto!! Thanks!
"Domenic" wrote: Assuming that Column A contains your data, enter the following formula in B1, and copy down: =(LEN(A1)30)+0 The formula will return 0 for cells containing less than 30 characters, and 1 for those containing more than 30 characters. Hope this helps! In article , sjs wrote: I have thousands of rows in my spreadsheet and I need to identify the cells that contain more than 30 characters. I know how to do a Validation on a cell but that only flags me when I enter data into the formatted cell, not when data already exists. Any ideas? tks, steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| How do you count number of characters in a single cell | Excel Worksheet Functions | |||
| How do you count number of characters in a single cell | Excel Worksheet Functions | |||
| Count unique alpha numeric "characters" in a common cell | Excel Worksheet Functions | |||
Threaded Mode
