Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2008

Tip: Looking for answers? Try searching our database.

Pasted Text Truncated?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
AJ - 15 Mar 2008 01:41 GMT
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
BoniM - 15 Mar 2008 02:03 GMT
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.

> 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.
[quoted text clipped - 17 lines]
>
> Thanks.....AJ

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.