Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limiting cell size to 25 characters
Does anyone know if there is a way to limit a cell/column to a certain number
of letters and/or numbers. I want the system to stop accepting data once I hit 25 characters. This would save me having to count the data to make sure I haven't exceeded 25. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limiting cell size to 25 characters
You can use Data/Validation to limit the length of the entry *after* the
entry is made (i.e., reject an entry 25 characters), but you can't limit cell entries at an arbitrary number of characters. In article , pj wrote: Does anyone know if there is a way to limit a cell/column to a certain number of letters and/or numbers. I want the system to stop accepting data once I hit 25 characters. This would save me having to count the data to make sure I haven't exceeded 25. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limiting cell size to 25 characters
Use data validation to limit minimum/maximum character lengths.
Click DATA in the menu, select VALIDATION. In the ALLOW combo box select TEXT LENGTH, in the DATA combo box select BETWEEN, then set your lower and upper limits -- Kevin Backmann "pj" wrote: Does anyone know if there is a way to limit a cell/column to a certain number of letters and/or numbers. I want the system to stop accepting data once I hit 25 characters. This would save me having to count the data to make sure I haven't exceeded 25. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Characters limiting | Excel Worksheet Functions | |||
limiting characters in a cell by formula | Excel Discussion (Misc queries) | |||
Limiting the number of characters in a cell. How? | Excel Discussion (Misc queries) | |||
limiting or deleting extra characters in a cell | Excel Discussion (Misc queries) | |||
Limiting characters in a cell | Excel Worksheet Functions |