Paste Link gives unknown value

[Guest]

I am using the paste link option to link one worksheet to another within the
same workbook.

Why is it that it is pasting the value but adding a small square like symbol
after the value? What is it and how do i get rid of it?

 

[Guest]

=SUBSTITUTE(A1,CHAR(10),"")

 

[Guest]

Thank you, besides adding a formula, is there anything else that I can do. I
would like to keep my worksheets as simple as possible. Should I be doing
something differently to prevent that symbol from even appearing?

 

[Guest]

Thank you, besides adding a formula, is there anything else that I can do. I
would like to keep the sheet as simple as possible. Should I be doing
anything differently to prevent that symbol from even showing up?

 

[Dave Peterson]

char(10) is the same as hitting alt-enter when typing something into the cell.

It forces a new line within the cell.

If that's what that square is, you can select the cells that have that square
box and then:

Format|Cells|Alignment tab|check wrap text