TabletWise.com
 

0805 Data Validation - Text Length w. Error Alert

1 minutes
Share the link to this page
Copied
  Completed
You need to purchase the class to view this lesson.
One-time Purchase
$99.99
List Price:  $139.99
You save:  $40
د.إ367.26
List Price:  د.إ514.18
You save:  د.إ146.92
A$139.71
List Price:  A$195.61
You save:  A$55.89
৳8,485.81
List Price:  ৳11,880.48
You save:  ৳3,394.66
CA$133.49
List Price:  CA$186.90
You save:  CA$53.40
CHF 91.49
List Price:  CHF 128.09
You save:  CHF 36.60
kr633.48
List Price:  kr886.90
You save:  kr253.42
€85.08
List Price:  €119.11
You save:  €34.03
£76.51
List Price:  £107.12
You save:  £30.60
HK$774.93
List Price:  HK$1,084.94
You save:  HK$310
₹7,488.96
List Price:  ₹10,484.85
You save:  ₹2,995.88
RM419.50
List Price:  RM587.32
You save:  RM167.82
₦37,846.21
List Price:  ₦52,986.21
You save:  ₦15,140
kr902.26
List Price:  kr1,263.20
You save:  kr360.94
NZ$151.72
List Price:  NZ$212.42
You save:  NZ$60.69
₱4,909.56
List Price:  ₱6,873.58
You save:  ₱1,964.02
₨16,815.81
List Price:  ₨23,542.81
You save:  ₨6,727
S$137.30
List Price:  S$192.23
You save:  S$54.92
฿3,110.83
List Price:  ฿4,355.29
You save:  ฿1,244.46
₺728.86
List Price:  ₺1,020.43
You save:  ₺291.57
R1,768
List Price:  R2,475.27
You save:  R707.27
Already have an account? Log In

Transcript

Hi there. in one of the previous videos, we saw how to validate user input based on the date inputs. Example, we can define the range, this time, our focus is going to be on column D. Now, here I want to have a technique built in which says whatever the ID code mentioned, it should not be exceeding four in length. In fact, to be more precise, it should be exactly four in length. So how do I factor that in? I choose the entire group of cells.

I go to data, I go to data validation, data validation, there, I click on and this time let me go to settings allow any value No, allow text length, and here you say for minimum and maximum for an error alert. I just gave a customized message that is in valid ID and error message I say the text length should be four. That's about it. As I press OK, let me test this out if I write a B one two, perfect, if I write a DD one to a ha, you notice I get the message which I had tried to populate the text lens should be for the try and let me correct this 1234. So this was about restricting the text length with the min or max. In this case, it was min max being the same thing.

That means it should be exactly for England.

Sign Up