Limited amount of letters in a cell

[agnessg]

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]

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

[#3]

Alternatively, you may use Data Validation and select "Allow: Text length". Then fill in "Data:", "Minimum:" and/or "Maximum:" as necessary.