How-To Geek on MSN

Everything You Need to Know About Data Validation in Microsoft Excel

To apply data validation rules to a selected cell or range, head to the "Data" tab on the ribbon, and click the top half of ...
NewsBytes

How to automate data cleaning in Excel

Excel's text functions, such as TRIM, UPPER, LOWER, and PROPER, can be used to clean up textual data. TRIM removes extra ...