#1   Report Post  
Posted to microsoft.public.excel.misc
Tcs
 
Posts: n/a
Default wrap text problem

I've had an occasional problem with Excel 2000, but now I'm also
having it with Excel 2003.

Occasionally when I copy text from a web page, the text won't wrap. In
fact, when I've had the column set to wrap, after copying my text, the
wrapping has been turned off. But now, even when I turn it back on,
the test *may*, or may *not*, actually wrap.

I've copied my webpage text into notepad first, then copied it from
notepad to Excel. Still doesn't wrap.

I've copied another cell that *IS* wrapping, pasted it to the cell
that is NOT wrapping, and it behaves correctly by wrapping. As soon
as I paste in my text, the wrapping goes away, even though wrapping
has been, and is still..."checked".

Does *anyone* have *any* idea what's going on? Other than some damned
"Poltergeist" I mean.

Thanks in advance,

Tom
  #2   Report Post  
Posted to microsoft.public.excel.misc
Karen
 
Posts: n/a
Default wrap text problem

Hi Tom,

After you've pasted your item into the cell, you should see a little
icon just to the lower right of it that looks like a paste button.
It's called paste options and if you click on the arrow, you will see a
choice to "match destination formatting".

Hopefully this will convert your copied item into the same format as
the cell.

Best of luck with this!

Karen

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word wrap problem Peter Excel Worksheet Functions 2 January 25th 06 09:49 AM
Text wrap problem when printing labels/textboxes chipshot Excel Discussion (Misc queries) 1 September 30th 05 10:21 PM
Wrap text ceases to function in Excel if cell exceeds 9 lines nycemail Excel Worksheet Functions 1 July 24th 05 06:09 PM
text wrap in merged cells SteveFerd Excel Discussion (Misc queries) 3 July 16th 05 12:46 PM
In Excel, using line wrap with text, some cells will appear as ##. RSCoyner Excel Discussion (Misc queries) 4 January 19th 05 11:21 PM


All times are GMT +1. The time now is 02:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"