Word wrap

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have copied and pasted a large quantity of text from Word to one cell
within Excel. I have used wordwrap, however although I can see all of the
text in the toolbar and when clicking on the cell, it does not display
completely in the cell itself
 
Check XL Help ("Specifications"). Only 1024 characters are displayed,
even though the cell can contain 32767 characters.

You can bypass this limit by inserting a manual Linefeed (CHAR(10)) at
least every 1023 characters.
 
Look in help, search for specifications and look if you hit the limits
text that is displayed in a cell is 1024 characters, some people say if you
use a lot of alt enter in-between lines you can display more than that
 
Thank you. I had already done that as well as experiment with the formatting
of the cell prior to entering this post.
 
How do I insert a manual linefeed in the text as a formula without it
appearing as text within the text.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why isn't Wordwrap not wrapping the last sentence? 1
WordWrap a TextBox on a UserForm 2
Controlling word wrap in a cell 2
Word-Wrap Help? 4
word wrap & pasted text 4
wrap text 1
cut/paste text into cells (wrap text) 1
Copy/Past from Word-spreadsheet format alignment disregarded 3

Back
Top