Paste Link gives unknown value

Y

YanYan

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?
 
Y

YanYan

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?
 
Y

YanYan

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?
 
D

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
 
Top