Thread: Soft Returns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rr rr is offline
external usenet poster
 
Posts: 20
Default Soft Returns

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