See Gord's post.

He describes how to do it en masse.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"RR" wrote in message
...
Thank you for your response. I will allow the cells to auto wrap next
time
but I still have to edit out the current ones. So, if the Hard Returns
were
already entered, is there an easy way to edit them out without having to
manually do it?

"RagDyer" wrote:

FWIW,

Your use of <Alt <Enter is really a *hard* return, where the text will
*always* break at that point, no matter how much room remains on the text
"line".

Soft returns may change position, depending on room available.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"RR" wrote in message
...
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