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
-
DVR
Kim Iversen
2 hours ago"Obama Belongs In Jail!" Tulsi Gabbard Exposes Entire Russiagate Hoax
65.7K37 -
LIVE
Robert Gouveia
2 hours agoBarrack Obama is GUILTY!! Declassified Docs RELEASED! Ghislaine Maxwell MEETING!!
2,425 watching -
LIVE
RalliedLIVE
44 minutes agoHIGH OCTANE WARZONE SOLOS ALL DAY
443 watching -
UPCOMING
EricJohnPizzaArtist
7 hours agoAwesome Sauce PIZZA ART LIVE Ep. #56: Bret “The Hitman” Hart Tribute with SoundBoardLord!
53 -
2:22:10
Nick Freitas
1 hour agoChurchill, Franco, and Rhodesia: Rethinking the Villains and Heroes of History
151 -
13:01
Professor Gerdes Explains 🇺🇦
3 hours agoUkraine in Turmoil: MASSIVE PROTESTS Against Zelensky ERUPT Nationwide
12 -
1:43:11
Redacted News
3 hours agoBREAKING! TRUMP DECLARES WAR ON OBAMA "TREASON" AS A DEEP STATE RINGLEADER IN RUSSIA HOAX | REDACTED
120K106 -
1:22:13
Michael Franzese
3 hours agoPablo Escobar’s Son Breaks Silence About His Father, Narcos, and The Cartel
23.5K6 -
LIVE
SpartakusLIVE
38 minutes agoThe $1,000 Spartakus Gauntlet || Huskerrs and Twitty
109 watching -
9:02
Hollywood Exposed
2 hours agoPiers Morgan's Guests ROAST DC's New Superman - It’s A Trainwreck!
4.08K1