Excel Data Validation - Text Length || MS Excel - Data Validation by Text Length
Excel Data Validation - Text Length || MS Excel - Data Validation by Text Length With this video, you'll learn how to apply data validation with Text Length or Limit text on any cell. With some sample data, I will show you how to use Data Validation in excel or Use of Data validation in MS excel. Data validation in MS Excel with the Limit of Text length in any cell is the most important for collecting data from end-users. I hope after watching this video you will be able to use it in your daily file.
Step By Step Process:-
Here is my demo Table
1st you need to select the required cell or Column for MS Excel - Data Validation by Text Length
here I used I column as per below picture
02 - Click on data Menu ( As per below picture )
03 - Click on Data Validation ( As per below picture )
04 - Again you need to click on Data Validation ( As per below picture ) then the system will show you a small popup window
05 - From this small pop-up window please do this 3 step
06 - Please follow the steps below
I hope after following these steps you will be able to use it in your daily file.
https://youtu.be/lELsjvemtOo
Excel Data Validation - Text Length || MS Excel - Data Validation by Text Length
Reviewed by Mizanur Rahman
on
July 24, 2021
Rating:
No comments: