Home

Limited amount of letters in a cell

%3CLINGO-SUB%20id%3D%22lingo-sub-879189%22%20slang%3D%22en-US%22%3ELimited%20amount%20of%20letters%20in%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-879189%22%20slang%3D%22en-US%22%3E%3CP%3EI%20was%20wandering%20if%20there%20is%20a%20function%20in%20excel%20that%20allows%20you%20to%20limit%20the%20amount%20of%20letters%20you%20can%20write%20in%20one%20cell.%20It%20is%20for%20when%20I%20lock%20the%20sheet%20so%20that%20users%20can%20only%20write%20in%20selected%20cells.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-879189%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-879278%22%20slang%3D%22en-US%22%3ERe%3A%20Limited%20amount%20of%20letters%20in%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-879278%22%20slang%3D%22en-US%22%3E%3CP%3Eyou%20can%20apply%20a%20Data%20Validation%20Rule%20to%20enforce%20this.%20use%20custom%20formula%20something%20like%20below%3C%2FP%3E%3CP%3E%3DLEN(A1)%26lt%3B10%3C%2FP%3E%3CP%3Ethis%20will%20not%20allow%20more%20than%209%20characters%20to%20be%20entered%20in%20to%20A1%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-879305%22%20slang%3D%22en-US%22%3ERe%3A%20Limited%20amount%20of%20letters%20in%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-879305%22%20slang%3D%22en-US%22%3EAlternatively%2C%20you%20may%20use%20Data%20Validation%20and%20select%20%22Allow%3A%20Text%20length%22.%20Then%20fill%20in%20%22Data%3A%22%2C%20%22Minimum%3A%22%20and%2For%20%22Maximum%3A%22%20as%20necessary.%3C%2FLINGO-BODY%3E
Highlighted
agnessg
Occasional Visitor

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
Highlighted

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

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