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

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

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

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

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

If you set the cells to wrap text, the squares will go away.

If you truly mean eliminate, EditReplace

What: CTRL + j

With: space


Gord Dibben MS Excel MVP

On Wed, 2 Jul 2008 11:45:00 -0700, 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