and Text filters to your spreadsheet. To make it easier for you to practice the filtering tasks we’re about to describe, we’ve created a downloadable Excel workbook with all the data we use in ...

These new Excel features for working with text and lists ... in Excel by choosing Data, Data Validation and choosing List in the Allow box on the Settings tab. Use a table on your spreadsheet ...

You need only the customer portions in Excel to create a relationship between that customer and a table that ... you might not: Text to Columns writes over the original data.