Prevent Spaces in a Cell - Excel Quickie 58

Описание: Prevent a user from inputting spaces into a cell in Excel - this uses custom data validation, but is quite easy to implement and, here, I'll show you how to do it.

Excel File: https://www.teachexcel.com/excel-tuto...
Excel Quickie 57:    • Fastest Way to Remove All Formatting in Ex...  

This Excel Quickie focuses on Data Validation in Excel. This allows you to control what a user enters into a cell and, if they input something that is not allowed, show them a warning and tell them what to do.

Data validation is very powerful, especially once you start using custom formulas, which is what is covered here.

Remember, the key to custom data validation in excel is a formula that outputs True or False!

I hope you enjoy this Excel Quickie!

TeachExcel.com

#excel #howto #excelquickie