Square symbol

  • Thread starter Thread starter Marc
  • Start date Start date
M

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.
 
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
 
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.
Click to expand...

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
 
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.

Rick Rothstein said:
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.
Click to expand...

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
 
Back
Top