| Channel | Publish Date | Thumbnail & View Count | Actions |
|---|---|---|---|
 Computergaga | 2018-02-13 21:24:22 |  41,380 Views |
In this example, we want to control the input of UK postcodes. So we need to allow the entry of text and numbers, but the text must be uppercase.
We use a formula with the EXACT and UPPER functions to create this validation rule.
Find more great free tutorials at;
https://www.computergaga.com
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm
Connect with us!
LinkedIn ► https://www.linkedin.com/company/18737946/
Instagram ► https://www.instagram.com/computergaga1/
Twitter ► http://www.twitter.com/computergaga1
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
