Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kris
 
Posts: n/a
Default Not all text wraps in a cell containing large amount of text

A cell contains several paragraphs of text. Only the first dozen or so lines
of text wrap. The rest doesn't wrap and each following paragraph can only be
seen partially.
  #2   Report Post  
Posted to microsoft.public.excel.misc
wjohnson
 
Posts: n/a
Default Not all text wraps in a cell containing large amount of text


I would try the following:
Select the column or Cell and go to "FORMAT CELLS" select "Alignment" -
"Vertical Alignment" - then select "TOP" and also ensure the "WORD WRAP
box is checked.
The default is usuall "bottom" and then if you have a narrow row - it
will sometimes only show the first line.

You might also have some paragraph returns entered. Insert a column
next to the column that needs to be "Cleaned" and then select the
"CLEAN" Function and then select the cell you want to "CLEAN"


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=495656

  #3   Report Post  
Posted to microsoft.public.excel.misc
Kris
 
Posts: n/a
Default Not all text wraps in a cell containing large amount of text

Thanks, It still doesn't wrap all when the amount of text gets too big.

"wjohnson" wrote:


I would try the following:
Select the column or Cell and go to "FORMAT CELLS" select "Alignment" -
"Vertical Alignment" - then select "TOP" and also ensure the "WORD WRAP
box is checked.
The default is usuall "bottom" and then if you have a narrow row - it
will sometimes only show the first line.

You might also have some paragraph returns entered. Insert a column
next to the column that needs to be "Cleaned" and then select the
"CLEAN" Function and then select the cell you want to "CLEAN"


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=495656


  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default Not all text wraps in a cell containing large amount of text

Kris

Excel Help on "limits" or "specifications" reveals that Excel will allow
32,767 characters to be entered in a cell.

However, it goes on to state that "only 1024 characters will be visible or can
be printed"

To work around this limitation, stick a few ALT + ENTERs in at appropriate
spots, about every 100 characters..

The ALT + ENTER forces a line-feed and expands the 1024 limit.

How far is not really known. Just experiment.

.........From Dave Peterson..........

I put this formula in A1:
="xxx"& REPT(REPT("asdf ",25)&CHAR(10),58)&"yyy"

And adjusted the columnwidth, rowheight and font size and I got about 7300
characters to print ok.

.........End Dave P.................

Failing that, use a Text Box to store the text or MS Word which is a word
processing application, unlike Excel which is not.


Gord Dibben Excel MVP

On Thu, 22 Dec 2005 21:06:03 -0800, "Kris"
wrote:

Thanks, It still doesn't wrap all when the amount of text gets too big.

"wjohnson" wrote:


I would try the following:
Select the column or Cell and go to "FORMAT CELLS" select "Alignment" -
"Vertical Alignment" - then select "TOP" and also ensure the "WORD WRAP
box is checked.
The default is usuall "bottom" and then if you have a narrow row - it
will sometimes only show the first line.

You might also have some paragraph returns entered. Insert a column
next to the column that needs to be "Cleaned" and then select the
"CLEAN" Function and then select the cell you want to "CLEAN"


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=495656


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
merged cells into one text cell, size varies dependant on text dat Jazzylady825 Excel Discussion (Misc queries) 0 December 9th 05 09:26 PM
huge amount of text in merge cell - want undone! rose Excel Discussion (Misc queries) 4 October 5th 05 08:08 PM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
Large amount of text in cells - Problem text.xls (1/1) Patrick Excel Discussion (Misc queries) 0 May 5th 05 01:23 PM
Formatting a cell as "text" in the number catagory. Ed Excel Worksheet Functions 3 December 7th 04 08:12 PM


All times are GMT +1. The time now is 11:49 PM.

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

About Us

"It's about Microsoft Excel"