Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 9
Default Pasted Text Truncated?

I'm trying to copy/paste some text from a Word document into a single Excel
cell in worksheet that was created by someone else.

The text has about 250 words/about 600 characters or so. There are about 5
major points, each point has about 4 bullet points underneath it. There's
about 25 lines of text. I've formatted the cell to wrap text, but the last
20 words or only display if I expand the width of the entire column - which
makes the other cells in that column much too wide - and the page won't
print as it should (a single page).

When I increase the length of the row it still doesn't show any more of the
text - which seems odd since it will show all of the text when I increase
the width of the column.

To keep the cell to a reasonable height and width, I've resorted to copying
the paragraph as an object and that works - but the downside is that I have
an outline surrounding the text.

Any ideas why this text won't paste and wrap properly? Suggestions?

Thanks.....AJ





  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 353
Default Pasted Text Truncated?

Excel limits:
Column width 255 characters
Row height 409 points
Length of cell contents (text) 32,767 characters. Only 1,024 display in a
cell; all 32,767 display in the formula bar.

Right click on the paragraph object... choose format... and on the colors
and lines tab change the line color to no line to remove the outline.

"AJ" wrote:

I'm trying to copy/paste some text from a Word document into a single Excel
cell in worksheet that was created by someone else.

The text has about 250 words/about 600 characters or so. There are about 5
major points, each point has about 4 bullet points underneath it. There's
about 25 lines of text. I've formatted the cell to wrap text, but the last
20 words or only display if I expand the width of the entire column - which
makes the other cells in that column much too wide - and the page won't
print as it should (a single page).

When I increase the length of the row it still doesn't show any more of the
text - which seems odd since it will show all of the text when I increase
the width of the column.

To keep the cell to a reasonable height and width, I've resorted to copying
the paragraph as an object and that works - but the downside is that I have
an outline surrounding the text.

Any ideas why this text won't paste and wrap properly? Suggestions?

Thanks.....AJ






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
how do I stop my text being truncated at RHS of a cell? JDN Excel Discussion (Misc queries) 4 January 11th 11 05:06 AM
Text in cells is truncated. Joe Excel Discussion (Misc queries) 5 February 21st 07 08:02 PM
Truncated text using vlookup to linked worksheet Patricia D Excel Discussion (Misc queries) 1 December 11th 06 03:20 AM
Truncated wrapped text cells in Excel RichK Excel Discussion (Misc queries) 1 April 12th 06 07:45 PM
Truncated text when copying text from one excel doc to another sunny pete Excel Discussion (Misc queries) 3 August 12th 05 02:11 PM


All times are GMT +1. The time now is 11:45 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"