With the Text Length option in the Allow drop-down menu found in the Settings tab of the

Question:

With the Text Length option in the Allow drop-down menu found in the Settings tab of the Data Validation dialog box, you can generate an error message when the number of characters in a cell does not match the number you define. Use this option to ensure that each cell in the range C1:C10 will contain at most five characters (including spaces).

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: