CellView

This add-in allows you to view exactly what is in a cell, including hidden and special characters. Display in either Decimal or Hex.

Quite often when doing copy and paste operations from a non-Excel source such as a web page, you will end up with special control characters in the worksheet cell. These characters are often not visible in a cell but can affect cell formatting and arithmetic and lookup formulas.