Forum Discussion
Limited amount of letters in a cell
I was wandering if there is a function in excel that allows you to limit the amount of letters you can write in one cell. It is for when I lock the sheet so that users can only write in selected cells.
2 Replies
you can apply a Data Validation Rule to enforce this. use custom formula something like below
=LEN(A1)<10
this will not allow more than 9 characters to be entered in to A1
- Alternatively, you may use Data Validation and select "Allow: Text length". Then fill in "Data:", "Minimum:" and/or "Maximum:" as necessary.
