I don't have a guess why it can be seen sometimes--but not others.

But I'd get a copy of Chip Pearson's addin: Cellview (for both pcs) to see
what's changed in that cell.

http://www.cpearson.com/excel/CellView.htm

YuChieh wrote:

I have a file from client.

A co-work views the file and he can see those little boxes (extra
characters) in the cells. For example - Northern(box)Virginia. He asked me
to fix it - replacing boxes with space, like "Norhtern Virginia".

When I open the file, I don't see the boxes. I see "NorthernVirginia".
Somehow, the system automatically took out the character. But I would like
to put a space betweem words.

Why would this happen?

My co-worker is using Excel 2002; I am using Excel 2003.

--

Dave Peterson