Soft Returns

[RR]

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

 

[ShaneDevenshire]

Hi RR,

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

 

[RagDyer]

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.

 

[Gord Dibben]

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

If you truly mean eliminate, Edit>Replace

What: CTRL + j

With: space


Gord Dibben MS Excel MVP

 

[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]

See Gord's post.

He describes how to do it en masse.