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.
you can apply a Data Validation Rule to enforce this. use custom formula something like below
this will not allow more than 9 characters to be entered in to A1