| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting characters
Thanks, just what I needed.
-- Howard "JLatham" wrote: Easy way to do it is to use Data -- Validation and choose 'Text Length' as the type of validation to use. Then you can set min/max/exact length to allow for the cell. Another way would be to use another cell to check the length. Say you want to check A1 for length: =IF(LEN(A1)<20,"Not 20 characters","Is 20 Characters") "Howard" wrote: Is there any way to count characters (spaces included) in a cell to insure that the characters in a specific cell do not exceed a preset number? Thanks everyone -- Howard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Characters in cells | Excel Discussion (Misc queries) | |||
| Counting characters | Excel Worksheet Functions | |||
| Counting characters within a cell | Excel Worksheet Functions | |||
| Counting Characters | Excel Worksheet Functions | |||
| Counting characters | Excel Discussion (Misc queries) | |||
Threaded Mode
