Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe Joe is offline
external usenet poster
 
Posts: 476
Default Text in cells is truncated.

Attempted all formating features including word wrap. Text in cells cut off
at column or at row. What do I do?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Text in cells is truncated.

Widen the column. Increase the row height?

If there's lots of text, add alt-enters every 80-100 characters. You may have
to increase the row height manually.

Joe wrote:

Attempted all formating features including word wrap. Text in cells cut off
at column or at row. What do I do?


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,696
Default Text in cells is truncated.

Not sure how much text you have in the cell, but have you tried dragging the
row or column wider? Once you wrap, it may not auto-fit the text.
Antoher option is to have only so much text in each cell.
=Left(A2,50)
then
=mid(A2,51,50)
etc.

Can change the 50 to whatever number of characters you want in the cells.

"Joe" wrote:

Attempted all formating features including word wrap. Text in cells cut off
at column or at row. What do I do?

  #4   Report Post  
Posted to microsoft.public.excel.misc
Joe Joe is offline
external usenet poster
 
Posts: 476
Default Text in cells is truncated.

Thanks for your help. I did try expanding both the column and rows. I am not
an expert user but can follow. How do I change the settings you mentioned
below. A2,50 etc. ?

"Sean Timmons" wrote:

Not sure how much text you have in the cell, but have you tried dragging the
row or column wider? Once you wrap, it may not auto-fit the text.
Antoher option is to have only so much text in each cell.
=Left(A2,50)
then
=mid(A2,51,50)
etc.

Can change the 50 to whatever number of characters you want in the cells.

"Joe" wrote:

Attempted all formating features including word wrap. Text in cells cut off
at column or at row. What do I do?

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Text in cells is truncated.

Joe

How much text in the cells?

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 Wed, 21 Feb 2007 10:09:05 -0800, Joe wrote:

Attempted all formating features including word wrap. Text in cells cut off
at column or at row. What do I do?




  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,696
Default Text in cells is truncated.

well, may be best to explain what the formulas do..

=Left(A2,50)
looks at cell "A2" and returns the first "50" characters.
So, if the text you're workign with is in a different cell, type that cell
in the formula. If you want to have, say, the first 200 characters brought
over, change the 50 to 200.

=mid(A2,51,50)
also looks at cell A2, starts with the 51st character and brings over
through the 100th character. If you were doing 200 characters as above, you'd
type 201,200.

so, if you have multiple cells with the same problem, just type yoru formula
to the right of the first one and decide if you want to drag across your rows
or down your columns.
If you're going across rows, put a $ in front of the A (or whatever column
you're pulling from.)
If down columns, $ in front of the 2 (or whatever row you're pulling from.)

Once you've go the formulas working for your first large cell, copy and
paste them to the right of or below the next big cell.

Hope that made sense...

"Joe" wrote:

Thanks for your help. I did try expanding both the column and rows. I am not
an expert user but can follow. How do I change the settings you mentioned
below. A2,50 etc. ?

"Sean Timmons" wrote:

Not sure how much text you have in the cell, but have you tried dragging the
row or column wider? Once you wrap, it may not auto-fit the text.
Antoher option is to have only so much text in each cell.
=Left(A2,50)
then
=mid(A2,51,50)
etc.

Can change the 50 to whatever number of characters you want in the cells.

"Joe" wrote:

Attempted all formating features including word wrap. Text in cells cut off
at column or at row. What do I do?

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 06:06 AM
Truncated text using vlookup to linked worksheet Patricia D Excel Discussion (Misc queries) 1 December 11th 06 04:20 AM
Truncated wrapped text cells in Excel RichK Excel Discussion (Misc queries) 1 April 12th 06 08:45 PM
Text Truncated on Vertical Chart Axis Label Adrian Excel Discussion (Misc queries) 1 October 20th 05 12:50 PM
Truncated text when copying text from one excel doc to another sunny pete Excel Discussion (Misc queries) 3 August 12th 05 03:11 PM


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