Premium Only Content

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
-
21:23
DeVory Darkins
1 day ago $4.82 earnedTrump makes STUNNING Admission regarding Epstein and WSJ settlement
7.69K68 -
2:47:03
Patriot Underground
17 hours agoTruthStream RT w/ Joe & Scott (7.30.25 @ 5PM EST)
25.1K24 -
11:25
Nikko Ortiz
13 hours agoMost Painful Fails
13.1K23 -
16:23
GritsGG
13 hours agoWorld Record Call of Duty Win Streak Attempting!
3.16K1 -
2:02:54
Side Scrollers Podcast
18 hours agoJOEY SWOLL/HULK HOGAN CONTROVERSY + ONLINE SAFETY ACT + MORE | SIDE SCROLLERS
25.9K2 -
1:05:44
Omar Elattar
9 months agoThe Digital Real Estate Expert: You're Being Lied To About Making Money Online!
4.61K -
10:53
Nikko Ortiz
2 days agoWORST Clips On The Internet
86K27 -
3:42:38
FreshandFit
13 hours agoREAL R*pe Victim Exposes Shannon Sharpe Accuser As Liar!
70.1K80 -
2:18:29
Badlands Media
15 hours agoDevolution Power Hour Ep. 376: Optics, Explosions & the War for the Narrative
144K43 -
37:46
Stephen Gardner
13 hours ago🔥Trump NEVER expected THIS WIN as Schumer has EPIC MELTDOWN!
44K34