 | |
| Excel Custom Data Validation (Use formulas to check for text, numbers and length) |
Excel's data validation feature allows you to build in validation checks in your spreadsheet templates. This reduces mistakes upon data entry. In this video, I show you how to use Excel's custom data validation feature to validate for complex combinations. You'll learn how to use formulas for creating your data validation.
Here we write a formula in the custom data validation box that checks for a specific combination of text and numbers. In the first example we take a look at validating for 1 letter and 4 numbers. In the 2nd example we look for specific characters inside the text and the last example we take a look at how we can validate for a combination of 2 letters and 4 numbers.
Related Topics:
Post a Comment