Hi RR,

Just turn on Word Wrap then they won't display and the text should wrap
where the Alt+Enters were done.

--
Cheers,
Shane Devenshire


"RR" wrote:

Within a cell I often force the text to wrap with what I call a "soft return"
which I do with an ALT-Enter to make the text wrap within the cell. However
when I copy the text in several column headings to another location with the
transpose command, it shows up with a square character where the solft return
was.

If I have a lot of these is there an easy way to eliminate all these square
characters and/or replace the square with a space so it show up all on line
of text?

Thanks
RR