Copy the data from the workbook that has the issue. Open a new Excel document and paste the data into the new workbook. Click the Save button in the quick access toolbar. When the Save this file ...

To learn more about using Flash Fill, read 6 ways to save time using Flash Fill in Microsoft Excel. Figure B Sometimes you won’t want a match. Instead, you’ll want to see a unique list.

If you find entering data into spreadsheets to be mind-numbing drudgery, then you probably don't know about these cool, time-saving tricks that make Excel 2010 do the heavy lifting for you.