When you import or paste data from an external source into Microsoft Excel, you may end up having some non-printable characters in your worksheet. Excel represents such characters as boxes.

Removing hidden metadata information from a Microsoft Excel spreadsheet is not difficult if you follow the steps laid out here.

How to Remove Characters in Excel 2007. Microsoft Excel, part of the Office software suite, allows you to create business-oriented worksheets composed of columns, rows and cells. Within these ...

Click on the Data tab. Then, click Remove Duplicates. Select the columns that might have copies in the dialog box and press OK. Excel will eliminate duplicate entries, leaving unique values.

Microsoft Excel: How to Remove a Drop-Down List. Excel's drop-down menus are useful for creating order forms and navigation for larger files like records of sales.