This is an excel file generated , so the formatting is already set. The file
has merge cells and word wrap set. The file generated fro ma .NET application
displays carriage return as small boxes in some systems and does not show the
small boxes in some systems.

"Joel" wrote:

There arre two things you can do. Not sure you will be happy with either
results because I don't know if you want the the text to appearr on a
seperate line or be continuous.

1) Go to menu : Format - Cells - Allignment
And change the setting on Wrap Text.

2) Use the worksheet Replace option. Highlight one of the square boxes with
mouse and Copy (Cntl-C). Then select entire worksheet (Cntl-A). go to menu

Edit - Replace

Click on From box and paste the square box using Cntl-V. It won't look like
the square box. Then press Replace ALL button.

"Merc" wrote:

I have an excel file with cells having data copied and pasted form word
document.
When I open this excel file, i nsome systems I see a small box for al lthe
carriage returns.
In some other sytems the carriage returns are displayed as simple blank
spaces.
What is the setting that can avoid dispaly of carriage returns as small boxes?

Thanks
Mercy