Edit, Fill, Justify

  • Thread starter Thread starter Hans Knudsen
  • Start date Start date
H

Hans Knudsen

In cell A1 I have a long text ( >> 253 characters). Now I do not want the
text to extend into column I so I select A1:H1, choose Edit, Fill, Justify
when I get the message: Text will extend belov selected range. When clicking
OK the text will be split into A1, A2 and A3 and in each of the rows 1, 2
and 3 extend up to and including column H. However, and that's my problem,
all characters after number 253 seems to be cut off.

Any suggestions?

Hans Knudsen
 
Select cell. Right click ..Format Cells... Alignment..Check ...Wrap Text
OR
Insert a line break within the cell using Alt+Enter
 
Just to add on

Cell will allow 32,767 text characters; however only 1,024 chrs will be
displayed in a cell.. All allowed characters will be displayed in the formula
bar.

If this post helps click Yes
 
Thanks, but the reason I want to use Edit, Fill, Justify is that I want the
text to appear in A1, A2, A3 etc. where the text in A1, A2, A3 etc. spill
over up to and including column I and I do not want to change the width of
columns A:I. With your suggestion the text will appear only in A1.

Hans
 
Back
Top