Chapter-6: Text Length Validation

We can allow to enter only text of certain number of characters in the Excel cells by using the Text Length Validation.

Below are the steps to apply data validation for Text Length:

  • Select the range.
  • Go to Data tab>>Data Validation>>Click on Data Validation.
Data Validation Option
Data Validation Option
  • Below given window will be opened.
  • Select Text length in Allow drop down.
  • Select between in Data drop down and put Minimum (Number of characters) and Maximum(Number of characters).
  • Click on OK button.

 

Data Validation Window
Data Validation Window

 

As we have given the Minimum as 2 and Maximum as 5 in the criteria. So a text 2 to 5 characters long will be allowed to enter. if the text with any other length will be entered, it will show “The value you entered is not valid

 

Error of Invalid Entry
Error of Invalid Entry

In Data Drop down below given items are available:

Items in Data drop down list
Items in Data drop down list

 

  • between: is used to allow to enter text which have length between given Minimum and Maximum criteria.
  • not between: is used to not allow to enter text which have length between given Minimum and Maximum criteria.
  • equal to: is used to allow the  text which has the text length as given in criteria.
  • not equal to: is used to not allow the  text which has the text length as given in criteria.
  • greater than: is used to allow all the text which have length greater than the number which has been given in criteria.
  • less than: is used to allow all the text which have length less than the number which has been given in criteria.
  • greater than or equal to: is used to allow all the text which have length greater than or equal to the number which has been given in criteria.
  • less then or equal to: is used to allow all the text which have length less than or equal to the number which has been given in criteria.

 

Previous ChapterNext Chapter