View Single Post
  #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?