restricting the user to enter more than 10 characters

Originally Posted by maddi1in

Hi,
I wnat to put some code on a cell / column that user is not able to enter more than 10 characters in the cell/column. if tries to enter further the system / excel does not take characters.
Thanks in advance...........
Maddi

select the range where you want to apply this setting.
go to Data > Validation
under Allow category select Text length
then Data: less than or equal to
and Maximum: 10
and hit Ok