Defining character limits

[Steelsilk]

I am trying limit the number of characters allowed in a specific range. I
have several columns, each with a different limit.

 

[AKphidelt]

Hilight the range... then go to

Date ----> Validation

Then change the drop down to "Text Length"
Then change the new drop down to Maximum
Then type in the maximum number of characters you want to allow.

You can then change the error messages that either warn or completely stop
people from entering data that is too long.

 

[Steelsilk]

Thank you. I knew I had done this before but I couldn't remember how.