Hosted on MSN

Excel's Custom Data Validation: A Trick You Didn't Know You Needed

Data validation in Excel lets you restrict what can be entered into a cell, whether whole numbers, decimals, dates, or a certain number of characters. However, one of the most powerful capabilities of ...

Stop inconsistent data at the 'entrance' before fixing it—Steps to create a dropdown list using Excel Data Validation and how to find values entered via copy-paste

When I aggregated the data, the same department was split into four."General Affairs Department", "General Affairs", "General Affairs Department " (with a trailing space), and "Soumubu" (in katakana).

"Fixing input errors again?" — Creating a spreadsheet that helps you spot mistakes with Excel data validation

Before you blame the person who entered the dataMisaki Sato, 34, has just become a leader of a six-person administrative team ...