Dena
Try Chip Pearson's CellView add-in.
Free download from here.
http://www.cpearson.com/excel/CellView.htm
Gord Dibben MS Excel MVP
On Wed, 1 Mar 2006 09:07:27 -0800, "Dena"
wrote:
Have a column that contains something I can't see. It's causing that entire
column to register when exporting to a different database. I can't find the
culprit - am guessing it's a tab or a line break that's in one of the cells.
In Word, I can view formatting marks. Is there a way to view those in Excel
so that I might find this rogue entry in a cell?