Explainry Tutorials to Expert in IT

How to limit text length in excel

Main Lesson: Data Validation in Excel

To restrict a user to enter a limited text length, execute the following steps:

1- Select the range of cells A3:A7.

2- In the Data tabs, from the Data Tools section, select the Data Validation.

3- From the appeared Data Validation box, select Text length from the Allow option, select less than or equal to from the Data option and finally enter the maximum number to restrict text length i.e. 5 in our example.

4- Press OK. Result. You will be able to enter maximum 5 characters in the selected cell.

Copyright © 2016 - 2020 Explainry.com | All Rights Reserved