Can I view stylistic formatting markup in Excel as in Word?
 

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?

Can I view stylistic formatting markup in Excel as in Word?
 

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?