You can easily create a drop-down list in Excel to limit the values that can be entered in a column. Here's how to set one up ...

REGEX is a smarter version of Excel's FIND function, which works well for basic lookups. However, REGEX handles more complex ...