Excel Custom Data Validation (Use formulas to check for text, numbers & length)

May 24, 2018 Drop Down Lists in Excel (Dependent, Unique Lists and other data validation lists)
Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials

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.

We also cover Excel's LEN, RIGHT, LEFT and MID functions.

Full Article: https://www.xelplus.com/excel-custom-data-validation/

★ Links to related videos: ★

Basics of Data Validation: https://rumble.com/v2u2rbm

★ My Online Excel Courses ★

Courses ► https://courses.xelplus.com/

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel #LeilaGharani