Defining character limits

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying limit the number of characters allowed in a specific range. I
have several columns, each with a different limit.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to limit the characters in a cell 1
LIMIT THE NUMBER OF CHARACTERS ENTERED IN A FIELD 2
Linked cells limited to ~253 characters unless source file open 3
Vlookup limitation 1
Limitations on Sumif Calculation 3
Number of characters in a cell for a Index/match function 11
Character limit in textbox 1

Back
Top