Square symbol

[Marc]

Hi,
I created a Excel sheet by using a DBF.
Some cell values contains SQUARE symbols at the end of the line.
I opened the same excel sheet in a different machine,
but there I cannot see that symbol.
My OS is Windows XP and using Office 2003
Pls someone tell me what is the reason for this.

 

[Pete_UK]

Those square symbols represent non-printable characters. You can find
out the code of, say, the last one by using this formula:

=CODE(RIGHT(A1))

It may return 160, which is the code for a non-breaking space
character.

Hope this helps.

Pete

 

[Rick Rothstein]

Those square symbols represent non-printable characters.

You can find out the code of, say, the last one by using this
formula:
=CODE(RIGHT(A1))

It may return 160, which is the code for a non-breaking
space character.

I'm thinking it may return 13... the CarriageReturn part of a CarriageReturn/LineFeed combination used as a "newline" character sequence in Windows.

--
Rick (MVP - Excel)


Those square symbols represent non-printable characters. You can find
out the code of, say, the last one by using this formula:

=CODE(RIGHT(A1))

It may return 160, which is the code for a non-breaking space
character.

Hope this helps.

Pete

 

[Marc]

Thanks,
But these symbols I can see only in one computer.
I opened the same excel sheet in different computers
I couldn't see square symbols in those machines.

Those square symbols represent non-printable characters.
You can find out the code of, say, the last one by using this
formula:
=CODE(RIGHT(A1))

It may return 160, which is the code for a non-breaking
space character.

I'm thinking it may return 13... the CarriageReturn part of a
CarriageReturn/LineFeed combination used as a "newline" character sequence
in Windows.

--
Rick (MVP - Excel)


Those square symbols represent non-printable characters. You can find
out the code of, say, the last one by using this formula:

=CODE(RIGHT(A1))

It may return 160, which is the code for a non-breaking space
character.

Hope this helps.

Pete

 

[Gord Dibben]

Download Chip Pearson's CellView add-in so's you can see what's in the
cells.

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


Gord Dibben MS Excel MVP