| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limit to 50 char only
Or, more simply maybe....
DataValidationAllow "Text Length" less than 51 Gord Dibben Excel MVP On Thu, 1 Apr 2004 23:57:56 +0200, "Frank Kabel" wrote: Hi try the following: - select the cell (lets say A1) - goto 'Data - Validation' and choose 'Custom' - enter the formula =LEN(A1)<=50 Note: this won't prevent copying longer data into this cell |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FIND 1 char in cell of any 3 char =True | Excel Discussion (Misc queries) | |||
| How do I get around the 255 char limit? | Links and Linking in Excel | |||
| 8500 cells with phone number(7 char.), wishing to add area code (10 char.) | Excel Discussion (Misc queries) | |||
| LIMIT NUMBER OF CHAR IN A COMBINE CELL | Excel Discussion (Misc queries) | |||
| Nested IF limit or Open parentheses limit | Excel Discussion (Misc queries) | |||
Hybrid Mode
